Chnaging the DB that Tables point to

[Haraki]

I have an Acces mdb with odbc links to about 100 tables to an oracle
production database. Is it possible to change the links all at once to my
test db without having to relink each one?

Thanks in advance for any help that can be offerred.

 

[jahoobob via AccessMonster.com]

Have you tried the link table manager? If all the tables were linked to one
Oracle db then if you Select All, check the Always prompt for new location,
and click OK you can select your test db.

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/tables/tbl0010.htm at "The Access
Web"