After opening a DB, Access keeps asking me to select an ODBC DSN, and to the to provide credentials.
The DB was created by someone else, but I am modifying it.
Before my last modification, the DB App asked you to select an ODBC DSN only once, immediately after opening it (it has an Autoexec Form).
After my last modification (I added a pass through query), it asks multiple times.
I created the pass through query to get around the 255 column limit.
The DB contains two links to two SQL tables, and now a new pass through query to one of the two linked tables.
I've created an ODBC connection definition that uses Windows NT Authentication to make it easier for the users of the app.
Does anyone know how I can get it to only ask for the ODBC one time when you start the App? Or better yet, only ask for it once, then use the same ODBC DSN every time after that.
Any help / insight to my problem would be greatly appreciated.
By the way, if anyone thinks that this post belongs in another Forum, please let me know.
JohnK