How do you RELINK tables in Access?

[bacon333]

I had a set of databases table located in the N drive. I moved the database tables to another drive M which keeps the same structure. is there an easy way to relink all the tables to the M drive instead of going through each database and relinking by hand?

I tried to use the linked table manager and it forces you to relink the tables manually by telling it where the new table. I have to do this for EACH table.

can anyone help?

 

[Kilrsat]

Originally posted by: bacon333
I had a set of databases table located in the N drive. I moved the database tables to another drive M which keeps the same structure. is there an easy way to relink all the tables to the M drive instead of going through each database and relinking by hand?

I tried to use the linked table manager and it forces you to relink the tables manually by telling it where the new table. I have to do this for EACH table.

can anyone help?

Select them all, and relink. If all the linked tables originally came from the same source, it will only ask you once. If you use multiple sources, check only the boxes that belong to one source at a time.

 

[bacon333]

What if the tables are Fox Pro Tables? Where each table is a seperate file, not contained within a database.

 

[Kilrsat]

Then I think you have to do them one by one. I've never fiddled with FoxPro links, only links to other access mdb files or MSSQL tables.