How to remove links from a database that refers to an invalid driv

N

Nilson G.

Somehow my database shows links to a drive (G) instead of the backend (or
vice-versa). How can I changed this condition to have my forms allow for data
entry and my reports to show the query ("..." buttom) again?
 
P

Pat Hartman\(MVP\)

Open the link tables manager from the database tools menu. Check the always
prompt box at the bottom of the form, select all the tables and then press
the button to run the link. Use the common file dialog to browse to the
correct back end.
 
N

Nilson G.

I'll try that. Thank you guys.

Pat Hartman(MVP) said:
Open the link tables manager from the database tools menu. Check the always
prompt box at the bottom of the form, select all the tables and then press
the button to run the link. Use the common file dialog to browse to the
correct back end.
Click to expand...
 
N

Nilson G.

Pat,
I tried to do that but it will not accept the Backend.mdb as a new location
(being that they are in the same folder). If you are refering to a different
file (common? or else) I can not find any thing in that same folder.
I don't know if someone made a copy of that backend to their computer and
created this mess (link) or if the "backup" program to the external drive (G)
caused that. Almost all my users have their "Access" mapped to their "G"
drive.
Thank you though.
 
Top