linking tables

[: : Chris Cleary : :]

I have a database that links to 12 tables on my local hard drive.
I use this database to make design changes, then upload it to a network
share.
The 12 tables in total come to 911MB so working from my local disk is a lot
faster when making design changes.

The 12 tables then need to be changed using the linked table manager to
repoint to the location of the 12 tables on the network

Is there a way I can write code or create a macro that will automate the
changes to where the linked tables are stored.

Any help with this matter would be greatly appreciated and I apologise if
this email causes any confusion as it was wrote in haste.

 

[Cheryl Fischer]

I think you might like the code found at:

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