Can't change linked tables to use trusted connection after upsize

[Tom Lee]

I used the Upsize Wizard to move a Access 2000 database to a SQL Server 2000
database and used the SA account to create the tables. Now I need to change
the options for the linked tables to use a trusted connection by default so
my users don't have to deal with the SQL login dialog every time they hit
one of the SQL tables.

The Linked Table Manager only lets me refresh the connections but will not
let me change the connection options. Any ideas?

Tom I.

 

[Tom Lee]

But if I do that I have to chose ODBC as the connection source. Is there a
way to specify an ODBC connection instead of a native SQL connection. Is
there a way to add the "Trusted=Yes" parameter to the connection string?

Tom L.

 

[Joan Wild]

Delete the links and recreate them using File, Get External Data....

 

[Tom Lee]

Oops.. I meant "specify a native SQL connection instead of an ODBC
connection".

 

[Joan Wild]

MDBs connect to SQL server via ODBC, not directly. An ADP connects directly
to SQL Server.

When you choose ODBC, you have the option of Windows authentication rather
than SQL Server authentication.