Linked Tables - SQL server login popup

[reign99]

Hey, I'm still using Access 2003 (if it ain't broke, don't fix it!) and am looking to push toward the latest version.

The problem I'm having is that every time the application is started, and a linked table is accessed (to SQL server using ODBC), it pops up the "SQL Server Login" box.

It uses a trusted connection, so you just have to hit OK, but the problem is you have to do it each time the app is started for the first interaction with EVERY linked table. That's a lot of annoying clicking.

How can I stop this? In 2003, and 2007 I believe as well if I remember correctly, this wasn't an issue.

Anyone have a work around for this?

 

[mdlueck]

Give this solution a try...

Linked Table Saved Password ADOX code
http://www.access-programmers.co.uk/forums/showthread.php?t=226468#post1155700

 

[reign99]

Thanks for the quick reply, I will check this out.

From reading through the function, it looks like it is essentially just recreating the link string to the tables. So essentially, if I delete all the linked tables and recreate them I should eliminate this issue?

If so that would be great, I will try that in a copy of the front end and see how it turns out. Thanks again!

 

[mdlueck]

No, do not delete. Just call that code in your application start-up to update the connection strings of the DAO Linked Table objects.

I repete, DO NOT delete the DAO Linked Table objects... merely edit the connection string contained within them.

 

[reign99]

No, do not delete. Just call that code in your application start-up to update the connection strings of the DAO Linked Table objects.

I repete, DO NOT delete the DAO Linked Table objects... merely edit the connection string contained within them.

Got it, thanks!