Hi all

Appreciate it if anyone can help with this one.

I'm trying to assist a friend of mine who has an Access97 database, to cut a long story short the server the MDB was on finally gave up the will to live this week so I've slaved the harddrive into another machine and copied the fl.mdb and flcore.mdb files onto another drive.

When I open the mdb in A2000 it complains about the linked tables in fl.mdb saying that the path \\server1\data is not valid.

Is there an easy way to tell all the linked tables to use f:\data (my USB drive) without deleting the links and rebuilding them (I didn't write the database so don't really want to cause more of a problem for him)

Best wishes
Graham

The easiest thing to do is to link all of the tables in their current location (use Select All) and they will come over with the same names, but with a "1" added to the end of the table names.

Check to make sure you have all the tables by comparing the old ones with the new ones by name.

Then delete all the old links.

Then rename all the new links to remove the "1"

Doing it in these steps will allow you to visually check every step of the process to make sure you are getting everything relinked.

Total time, about 2 minutes if you work slowly.

Everytime you move the back end, you will need to redo this with the front end.

Does this help?


mmcdonal

If your using AC97 then providing you have it there is an add in for managing linked tables. I think on later versions it is an actual menu item within the tools menu. When you open it you are presented with a list of linked tables. If you click on the select all button and then place a check in the "always prompt for new locations" then click ok it will go through each linked table and prompt you for a new location for the database you are linking to. I use this method myself quite a bit as I have a system with many front ends accessing a group of 3 databases. The method mmcdonal suggested also works. Mine is just an alternative.


Fig

For 2000 & later the menu for managing your linked tables is:

     Tools/Database Utilities/Linked Table Manager


-Phil-