How to Suppress SQL Authentication when linking from Access via DSN

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