How can I change Links to all tables? 2

[AccessVB]

I have about 100 tables in my front end and I wanted to change the links so that they look a different backend than what it is currently. The problem, it asks for a new location for every table, how do i update the links for all tables at once?

 

[scriverb]

If using A97 in design view select Tools / Add-ins/ Link Table Manager. This windows allows you to select your linked tables individually or all at once and browse to a new back-end for linking.

If using A2k then it is Tools/ DataBase Utilities/ Link Table Manager.

Good luck.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[AccessVB]

Using A2k. But when I do that it asks for a new location for each table instead of applying the new location that I pick to all tables. Any ideas why it would do that?

Thanks.

 

[scriverb]

Uncheck the box at the bottom where it says Always prompt for new location. This will keep it from prompting each table.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[AccessVB]

Thanks, there is a new location that I need to specify though. It is the same for all tables, nevertheles, it is different from the current location of the backend.

Any ideas?

Thanks a lot.

 

[scriverb]

Then you will need to check the box. You could also create a form to relink all linked tables to a new location. That requires a little bit of programming though.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[dhookom]

I always add code that does this. There is sample code at

http://www.mvps.org/access/tables/tbl0009.htm.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.