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

[Guest]

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?

 

[Joseph Meehan]

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?

Re-link the table.

I have not done this in a long time, I believe you can just re-link, but
you may need to delete the existing linked table and make a new link to it.

 

[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.

 

[Guest]

I'll try that. Thank you guys.

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.

 

[Guest]

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.

 

[Joseph Meehan]

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.

"Pat Hartman(MVP)" wrote:

I don't know what exactly is different for me and you, but I just tried
it and for me it linked no problem. I am on XP both Windows and Access.