General discussion

Locked

MS ACCESS 2000

By flipjive ·
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)?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by a.barnes 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...

Collapse -

by timfox 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

Back to Web Development Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums