Reconnecting Linked tables to SQL Server

R

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
 
R

Randy K

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top