linked tables

G

Guest

A client is using Access03/WinXP. When she opens the database and tries to
run queries or open the linked tables,she gets and ODBC connection failed
error. When going into the linked table manager, the tables are displayed as
such: tMfg_Order (DSN=IMDB2). She changes it to read DSN=IMDB3 and everything
works as it should. When she closes the database and reopens it, it is once
again pointing to IMDB2. How does she keep this from changing back?
 
G

Guest

On the linked table manager there is a checkbox that will prompt the user to
direct the link to the table EVERY time, sounds like in her case she may want
to check that box so that she can always point it to where she wants.
 
G

Guest

The database has 25+ tables. Wouldn't checking that option require the user
to direct the link for every table?
 

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

Similar Threads

Is there a way to automatically relink linked tables when opening. 1
Best way to deploy Access read-only database that is linked to SQL tables 6
How to configure the user and password for MySQL 2
Access 2003 ODBC connection failed 1
linked tables read only 1
Linked Oracle Table in Access 1
ODBC Linked tables keep on getting error 3151 5
DSN for Linked SQL Tables 1

Top