SQL Server Authentication problem

I am attempting to update an Access application to connect to an SQL Server 2000 database on Windows 2003 through ODBC. The Access application was connecting to Oracle 8.1.7 in the past and now the database is being upgraded. I have re-linked all the tables to the new SQL Server database. I want the tables to be linked automatically as soon as the Access application is opened.

On the SQL Server database I have set it to use 'Mixed' authentication. I have setup a user on the database that has Read only access. On the client site I have setup the ODBC Data Source Administrator with a new System DSN which uses the SQL Server Driver. The new system DSN specifies that the SQL server will verify the authenticity of the login "with SQL Server Authentication using a login ID and Password entered by the user". Below this the Connect to SQL Server to obtain default settings for additional configuration options is checked and the login ID and password are entered. When a test on this connection is run, it Connects successfully.

On the Access side I have a macro using the Transfer Database action to link the tables which uses an ODBC connection with the following values. ODBC;DSN=;SERVER=;UID=;PWD=;DATABASE=
There is also a line of code which runs to link the tables which uses the DoCmd.TransferDatabase acLink, "ODBC Database", ODBC;DSN=;ARSERVER=;UID=;PWD=;DATABASE=", acTable, _
"dbo.table_name", "Temp Link Item", False, True

Everytime I open the Access application and run it I receive the following error - see attached ConnectionError.doc.
Then it prompts me with a SQL Server Login box. The login box has the name of the server. A check box with a check mark to indicate "Use Trusted Connection" and the login ID and password are greyed out, but it is my network login ID.
If I uncheck the "Use Trusted Connection" and enter the USER ID and password set up on the database the connection will go through and I can then use my application. The next time I close down the application and open it again I have to do the same thing over again.


I'm not sure if I am missing something on the Database or if there is a file such as the TNSNames file with oracle that I am missing.

Any help would be appreciated.