We are using Access 2016 and SharePoint (our Office 365 package). I have built a 7 table Access database and made these tables linked to SharePoint lists (the tables in Access show as the yellow icons). This works well on my workstation and I can work on this Access database both online and offline (using the External Data-Web – Linked Lists – Work Offline icon)
I have given all users Admin rights to these linked lists on the SharePoint site
When the Access database file is copied to another workstation (another user) and then opened on that workstation Access just sits trying to open then fails, goes through the “trying to find an answer to the issue” and “trying to recover data” and then closes
Has anyone any ideas please?
This is due to how Access authenticates access to Sharepoint; the credentials are cached locally, and by user. Access is attempting to connect to these external lists, but has no credentials to do so.
This is an educated guess, but I think Access is looking for credentials in a location that doesn't have any for the current user; this is going to be a common issue for shared frontends with external tables in Sharepoint. Why it doesn't ask for credentials, I have no idea. That seems like the logical use case for when credentials don't exist.
To resolve this, I used a modified process from here:
Answered by fbueckert on December 19, 2020
1 Asked on December 27, 2020
2 Asked on December 25, 2020 by m-todd
2 Asked on December 25, 2020 by cherubel
1 Asked on December 25, 2020
1 Asked on December 24, 2020 by user93142
1 Asked on December 24, 2020 by k-jones
1 Asked on December 23, 2020 by rizingfenix
2 Asked on December 22, 2020 by dominica
1 Asked on December 22, 2020 by aurumpotabile
1 Asked on December 21, 2020
1 Asked on December 21, 2020 by sven-rsser
0 Asked on December 21, 2020 by gunilla
1 Asked on December 19, 2020 by anders
1 Asked on December 19, 2020 by klewis
1 Asked on December 19, 2020 by geoffe
2 Asked on December 18, 2020
Get help from others!