Web Development

General discussion



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.

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:

Hope it helps.

Related Discussions

Related Forums