Recently moved my backend into SQL Server and the cloud.
and now on two separate occasions I have completely lost the ability to connect to the ODBC.
I will have been working in the access front end just updating data. then leave to go do other things and when I come back several hours later I am unable to access any of the linked tables.
when ever clicking on a linked table I get an instant error message that says
its like its not even trying to connect.
what is really odd is that I can still connect and access everything via SSMS and can even access the back end using Excel
But the Access Front end is like it is lost or locked out.
I have tried Rebooting the Access app, my computer, my router. tried accessing the backend (still from my computer but on a different network)
I am also unable to re-link the tables using the Linked table manager
The first time I deleted all of the linked tables and went through the entire process of bringing everything back in and it worked fine.
This time I just deleted one of the linked tables and went through the process of bringing it back in, and in doing so now all of the tables are working again.
Any thoughts or experiences would be appreciated, Thank you