Access: 2007
SQL Server: 2014
OS: Windows 10
Currently my linked table connection string like this:
Code:
ODBC;DRIVER=ODBC Driver 11 for SQL Server;SERVER=HOSTNAME;APP=2007 Microsoft Office system;DATABASE=MyBE;ConnectRetryCount=3;TABLE=dbo.Audits
My app works fine but I have to input SQL server user name and password every time when I start my Access App.
So I change my linked table connection string like follow:
Code:
ODBC;DRIVER=SQL Server;SERVER=HOSTNAME;DATABASE=MyBE;UID=user;PWD=Password;TABLE=dbo.Audits;
But after I RefreshLink and restart my Access app. Access took ages for 'Checking attached tables' and everything become very very slow.
Do I miss some configuration in my connection string or Access itself?
Any suggestion?
Cheers,