Make file

[tbprog]

I have a collection of three mdb files which link together to form an application. In order to transfer from the development system to the live system I need to copy them to new directory, Run functions in the databases to relink tables and reset References to library data bases. Can I create a file that will all do this. If I do it in Access the code is not sequencial and will still be copying a file while tryingto open the file etc.
Any thoughts.

 

[Pat Hartman]

Rather than running the relink and reference code just once when you install the db, you should probably set it to run everytime the db is opened. Although you probably won't be moving the files once the app is in production status, you have much less control over the references. The references break for several reasons, one of which is if software with newer versions of the .dll's that Access needs is installed. So an app that was working fine could have broken references tomorrow because someone installed new software on that PC.

 

[tbprog]

Thanks Pat.
Thanks.
This is fine for the mdb which is called first, however this 1st mdb uses 2 others as libraries and I have not found a way of relinking a reference in the library mdb without opening it. The reference collection has to be accessed via the Application object.
Tom