How to Link your Access DB to Sharepoint?

squeakums

Well-known Member
Joined
May 15, 2007
Messages
602
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?
 

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,510
Not that I know of. It sounds like a bad idea since Access is not for use over http networks.
 

Micron

Well-known Member
Joined
Jun 3, 2015
Messages
1,742
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.
 

stumac

Active Member
Joined
Jul 16, 2010
Messages
470
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.
 
Last edited:

Forum statistics

Threads
1,077,907
Messages
5,337,096
Members
399,125
Latest member
manibiotech

Some videos you may like

This Week's Hot Topics

Top