Hey Everyone,
I am really stuck here if anyone can help or point me in the right direction.
I have a small Access Reporting app that links up to a SQL 2005 Database (linked tables) via a system DSN and pulls the data required for the reports. The issue at hand is, whenever the Access App is launched, the user is prompted for a username and password to the SQL Database. I have in my Access script, an embedded connection string complete with username and password trying to bypass this, but it does not seem to matter. No matter what I do, the SQL Authentication window appears.
Does anyone know how to suppress this and have it use my connection string within the code?
Thank you so much in advance!
Dallas
