Putting Access database on SharePoint
I am new to SharePoint and have little understanding of how it works, so please bear with me if I am asking a stupid question.
What I want to do is enable 3 or 4 users located in different towns to connect and use an Access back end database. Would this be possible via SharePoint?
dmkg
November 19th, 2010 7:05am
As always with a Access + SharePoint question we need to know which Access version and which SharePoint version.
Your usual method would be to have an Access table that is synchronized with a SharePoint list. The users would usually access the SP list via a browser but their changes would also be available in the Access table.
Note that this works at table NOT database level. It is available from Access 2007 and SharePoint 2007 upwards.
SP 2010 "FAQ" (mainly useful links):
http://wssv4faq.mindsharp.com/default.aspx
WSS v3 FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
Both also have links to extensive book lists and to (free) on-line chapters
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2010 7:18am