Hi
I have a strange problem with Access 2016 (office 365 home) and Sharepoint online (plan 1) connection. I use a front end database to connect to Sharepoint lists. Furthermore, I have 3 calendars on Sharepoint that are syncing with Outlook. This works fine on two laptops and one windows tablet. In my office (4 pcs in local network, 3 windows 8.1 pro and 1 windows 7 professional) every time I try to open the front end data base I receive an error message (The Microsoft Office Access database engine could not find the object '<linked table name>'. Make sure the object exists and that you spell its name and the path name correctly). After I try to reconnect the sharepoint lists I receive again an error message (Microsoft Access object “<name of the data base front end>” cannot contact the server. Check the spell of the path or contact the server administrator). It does not prompt me to login!! The only way to solve the problem is really a tricky way. I have to open Outlook and click into a connected calendar. It appears sent/receive error and a pop up window that prompts me to login with Microsoft account. If I try to login with my username (owner of Sharepoint) sent/receive status is restored but Access database still not works. If I login with my secretary username (collaborator of Sharepoint site) everything works fine!! After shutting down the computers and coming back the next day the problem starts from the beginning!!
Is there any idea what could be the solution? Could be a local network issue?
Thanks