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

  • Thread starter Thread starter Tom Lee
  • Start date Start date
T

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.
 
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.
 
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.
 
Back
Top