Linking a split database

[Tony Williams]

Hi all!
I have a split database. I have updated the back end with new forms etc. I
know this sounds a simple question but how do I update to my new version? Do
I just give the amended back end the same file name and copy it into the
existing directory. Will the links still be there? Obviously because I am
doing this on two different machines the directory and drive references will
be different. How do I edit them to make the old front end speak to the new
back end?
TIA
Tony Williams

 

[John Vinson]

Hi all!
I have a split database. I have updated the back end with new forms etc. I
know this sounds a simple question but how do I update to my new version?

Ummmm... the backend should have Tables, and ONLY tables. Why are
there forms etc. *in the backend*?

Do
I just give the amended back end the same file name and copy it into the
existing directory. Will the links still be there? Obviously because I am
doing this on two different machines the directory and drive references will
be different. How do I edit them to make the old front end speak to the new
back end?

Please explain a bit more about what you're updating and where. You
may indeed need to use Tools... Database Utilities... Linked Table
Manager in the frontend to relink to the tables in the backend, if (as
I suspect) you have actually upgraded the *frontend*. You can also use
VBA code in the frontend to automatically do the relinking.

 

[Tony Williams]

Thanks John. Thanks for the last bit of sound advice!!!
Tony