Web Development

Ask something
Discussion Locked

MS ACCESS 2000

0 helpful
2 replies

by flipjive

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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)?

2 replies

by abarnes70

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...

This discussion is closed to new replies.