Oct 15 2010, 07:36 AM
I've copied an access database and its backend database from one computer to another and although I've previously successfully relinked tables using the Linked Table Manager, the Linked Table Manager has suddenly started to request a separate link for each table. Previously it would pass through the tables to be linked and relink them in the one pass. I have about 100 tables so separately linking each one would be time consuming. I've been doing this for some time, so what could I have done or is there a setting I need to be aware of to avoid this please?
Oct 15 2010, 07:47 AM
Access behaves this way if there is more than one current source file specified for the tables you are re-linking.
You will ned to select tables from the same current source for relinking and then you will only be asked once for the new source for that set of tables. Obviously you will have to go through this once for each current source file.
Oct 15 2010, 08:45 AM
You may want to try this free utilitiy: Relink / Swap Between LIVE, TEST and LOCAL Data
hope this helps
Oct 16 2010, 05:15 AM
That's solved it. Great thank you. I'll certainly have a look at the utility you suggested.