Relinking a lot of tables at once

[keyel1971]

Access 2003, Windows XP
Here's the problem:
I have a ton of table (200) that are linked IN to database X. They are linked from:
\\ a \ many different levels of folders here \ database.mdb

As of today, they migrated my A drive to the B drive. So all the links are broken in database X. Is there script I can run to update all the links in database X so that only the "A" part is updated to "B"? Or do I have no choice but to relink each one individually?

Thanks!

 

[speakers_86]

First off, you should not bury Access files in a large directory. You want those files as close to the root as possible. Otherwise you can get some weird happenings.

Secondly, you can use JStreet Relinker. It works beautifully.

 

[keyel1971]

Thanks, I'll give it a shot. I have no choice but the current set up. We get one, and only one, database (Access) that is allowed to be "hooked up" to Business Objects software. We need many tables linked to Bus Obj, so we have no choice but to use one database with tons of tables linked in.

 

[keyel1971]

I tried the jstreet and the macro to change links, and it does work, but you still have to navigate to EACH database where you want to re-link from. I'm looking for code that says "okay, in each link for each table in this database, replace the "\ \ A" portion of the link with " \ \ B". Is there a way to do that?