Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

MS ACCESS 2000

Locked

I have an ACCESS database split into 2 files (interface and data files) where the tables are linked. How can I have the Interface file automatically link tables to the Data file, whenever the Data file pathway changes (w/out manually using the Linked Table Manager)?

Topic

Reply To: MS ACCESS 2000

In reply to MS ACCESS 2000

I’d use VBA code to reconnect the tables every time the database is opened, and disconnect them when closing the database. It’s a long time since I’ve written that sort of code, but if you need me to I can probably find some old stuff I’ve written in 97 that could be converted to 2000…

Reply To: MS ACCESS 2000

In reply to MS ACCESS 2000

Check out the following link for Dev Ashish’s site:
http://www.mvps.org/access/tables/tbl0009.htm

Hope it helps.
Tim

[Author]

Replies