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?