Software

Ask something
Discussion Locked

How to change the Pointer in an Access?

0 helpful
5 replies

by roncone 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I currently have an MDB file that is linked to another MDB file. The first file is for a user name,password and viewing of the second database file. Due to network changes we had to move these files to a new share. Since the move we are unable to open the database file because of path error. The fist MDB is still looking at the orignal share where it was. I looked in the file but was unable to find where the path was listed. Does anyone know how to change the path or even how to find it?

5 replies

by r. a. caluste

If using Access 97, Go to tools/Add-ins/Linked Table Manager

In Xp or 2000, Right Click on the Linked table and select the Linked Table Manager from the pop-up menu.

Hope this helps.

by john_wills

The previous answer, regarding the Linked Table Manager, is right, but the LTM is not easy to handle: I usually delete the pseudotable in my database and link with Get etc. to the new table. Alternatively, one can do the link first, then the delete,then rename the newly linked table.

This discussion is closed to new replies.