convert my odbc conections to dsn-less conections

[rsbutterfly16]

hi all, i have two 2003 access databases with linked tables to my sql server 2000. For one access database i used the upsize wizard to send my tables to a new database in sql server and for the other database i went to file, get external data, linked talbe, odbc database and created a new odbc. I keep getting an error message for my other users sql server error 18456, i would like to try to make my conection an dsn-less conection.. can someone tell me the steps to do this..

 

[rsbutterfly16]

this is what i got from another forum but don't know exactly where to put it

Dim db As Database
Dim rs As Recordset
Dim sSql As String
Dim tdf As TableDef
Dim tdf_change As TableDef


Set db = CurrentDb
For Each tdf In db.TableDefs
Set tdf_change = db.TableDefs(tdf.Name)
tdf_change.Connect = newconnectionstring tdf_change.RefreshLink
End If




Windows authentication connectionstring:

ODBC;DRIVER=SQL Server;
SERVER=your_server_name;DATABASE=your_database_name;Trusted_Connection=Yes