Linked Tables - SQL server login popup
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?