Hi Guys,
I have a couple of clients with access 2016 FE and SQL BE. The application has a module that re-links all the tables when it opens. Today however, I keep getting error: sqlstate s1t00 login timeout expired:
When I click ok, it pops up box with connection IP and login details, that I click ok and it continues to login, this happens randomly 1, 2, 3 or 4 times, I am connection 72 tables.
I have tested the login using the ODBC to connect and test connection, both 32 & 64bit and they work fine, even using SQL Studio Manager, this to connect with no issues
The problem I have also is I need to send out an updated version of the application, but don't want to introduce a problem to my client users?
Is there a way to identify what's causing the timeout from the application.
All research I have done have suggested doing what I have done, so I am at a loss what and how to check next steps.
Thanks in advance
Les