Reconnecting Linked tables to SQL Server

[Randy K]

I'm not an MS Access programmer but do use it as a tool. One of the
users created some linked tables to SQL server using an ODBC
connection. If we close the database and reopen it we can an error
when trying to open the linked tables. We have to relink them. Is
this how it suppose to work? If so is there an easy way to relink the
tables programmatically when opening up the Access mdb?

Thanks, BTW we are using SQL Server 2000 w/ MS Access 2000

 

[dbwiz.com]

What kind of ODBC connection is your DSN? I recommend using System or
User DSNs.

Thanks,
www.dbwiz.com

 

[Randy K]

We set up File DSN connections. If that's the problem I can easily od
System or User DSNs.