richard1458
Instructor
I have tried reconnecting linked tables at runtime using the very helpful suggestions in thread181-38038 .
It works fine on two different computers that store their data on different drives (one has drive C:, the other has drive Z:, with folder\datafile names the same in both cases). However, I still have the following problem:
When I copy the 'front-end' database from one computer to the other, the first time I open it, it gives me an error message that it can't find the linked tables. In other words, it is trying to link to the tables using the previous settings before running the AutoExec macro that runs the 'ConnectToData' code. Is there a way to either:
i) ensure this AutoExec code runs before Access tries to link to the existing linked tables OR
ii) Trap the error message, and then run the ConnectToData code?
(By the way, I don't want to go any further down the 'Map Network Drive' route - other people use this database on their machines, and I am the only user trying to share it across a network connection, and also I'm not in a position to suggest they fiddle with their network settings)
- Richard
It works fine on two different computers that store their data on different drives (one has drive C:, the other has drive Z:, with folder\datafile names the same in both cases). However, I still have the following problem:
When I copy the 'front-end' database from one computer to the other, the first time I open it, it gives me an error message that it can't find the linked tables. In other words, it is trying to link to the tables using the previous settings before running the AutoExec macro that runs the 'ConnectToData' code. Is there a way to either:
i) ensure this AutoExec code runs before Access tries to link to the existing linked tables OR
ii) Trap the error message, and then run the ConnectToData code?
(By the way, I don't want to go any further down the 'Map Network Drive' route - other people use this database on their machines, and I am the only user trying to share it across a network connection, and also I'm not in a position to suggest they fiddle with their network settings)
- Richard