I have never attempted this before. But, is there a way to place your Access DB on SharePoint, but have it linked to where it saved in the folder its linked to? Also, multiple users should be able to open it correct?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to Link your Access DB to Sharepoint?
FWIW, M$ has stopped supporting integration of Access with SharePoint if I'm not mistaken. For a multi user db, everybody should have their own front end connected to the back end tables on a network share - no wifi.
Upvote
0
Access supports migration of the back end to SharePoint, it basically creates lists within the SharePoint sites, imports your data into them and then creates a linked table in their place within the Access file. I have used this a couple of times, however, have had a couple of small issues.
Some of my primary keys/foreign keys went out of order therefore the related data was then related to the incorrect record (this only happened with one table).
A couple of the data types were slightly different, therefore required tweaking on the front end.
I didn't save the FE within SharePoint, as others have said this is bad practice with Access as multiple users shouldn't be using the same FE concurrently.
The SharePoint lists were exposed to anyone with access to that site. They can be hidden, however aren't by default.
if you are considering trying to migrate data to SharePoint I would recommend thoroughly testing it on a copy of your file within a private SharePoint site as there are probably other compatibility issues that I didn't experience.
Some of my primary keys/foreign keys went out of order therefore the related data was then related to the incorrect record (this only happened with one table).
A couple of the data types were slightly different, therefore required tweaking on the front end.
I didn't save the FE within SharePoint, as others have said this is bad practice with Access as multiple users shouldn't be using the same FE concurrently.
The SharePoint lists were exposed to anyone with access to that site. They can be hidden, however aren't by default.
if you are considering trying to migrate data to SharePoint I would recommend thoroughly testing it on a copy of your file within a private SharePoint site as there are probably other compatibility issues that I didn't experience.
Last edited:
Upvote
0
Similar threads
- Solved
- Question
