relinking tables in Access 2000

[Rich]

I have a .mdb which links in some tables from two
different databases on a SQL 2000 server.

Every time I open it, I have to use the linked table
manager wizard to relink the second
group of tables. I only have to hunt down the the .dsn
for one of the tables in
the second group to relink all the tables in the second
group.

Is there any way of getting Access 2000 to hold onto
the .dsn for the second
group of tables like its seems to do for the first group?

Thanks in advance
Rich

 

[Joe Fallon]

Whenever you create a linked table you can save the password by checking the
Save Password box on the screen where you get the list of tables. Then the
connection information is stored with the linked table definition. You can
see some of it in the properties of the linked table. (You can't see the
saved password.)

I can link to 2 different SQL Server databases in A97 and save the password
to each and then close the .mdb and re-open it and then open each table
witout re-linking.

 

[Joe Fallon]

Try re-linking the tables.
When you select the DSN use a SQL Server account not a Trusted Connection.
Then when you get the list of tables in the database click the Save Password
checkbox.