There are quite a few posts of VBA to bulk relink tables in Access... however, in my one-off case, the easiest thing to do was to create a new database and import the forms, queries, reports, and vba modules but not the tables.  Then create table links -- this time, properly to a DSN.

However, the aforementioned code can be found here:

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

Good for repetive use, I guess.

Related Scribbles:

MS Access Notes

---

ID: 768
Author:
leonard
Date Updated:
2006-05-03 12:17:09
Date Created:
2006-05-03 12:17:09

Edit

---

Comments?

 >> Leonard Chan's Homepage  >> Scribble Web  >> Bulk change linked Access tables

leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.