Linked Table manager for Multiple tables

[JuliePritchard]

I have a forms database and a 'data' database with all the tables on it. Occasionally I need to 'repoint'(change the path of) the forms database to all the 'data' tables in the 'data' database using Linked Table Manager.
When I first started using this, I could repoint all the tables in one hit, using Select All, but now Access wants me to point them one at a time.
Does anyone have any idea what might have changed ??

Julie

 

[rochelle]

One of your tables is pointing to a different database from all the others. If instead of selecting all the tables, you select only the tables that are all from the same database, it will let you repoint all of these tables in one hit.

Open the Linked Table Manager and very carefully review the paths of each of the tables. As long as it keeps asking you to change the paths one table at a time, you've got at least one that's different in the bunch. If you still can't see it, try selecting 2 or 3 at a time and see if it lets you change at least those in one hit. Eventually, you'll find the one that's messing you up.

 

[JuliePritchard]

Thanks for that