Change the location of linked tables

[Badeye]

Hi All,

I have database that is currently split, however i now have a duplicate backend that i am to keep historic record. What i would like to do is from the front end press a button and switch the linked table paths so i can search the data from the backend with the historic information in and then go back to the other backend with the click of a button.

Cheers,

Si

 

[gemma-the-husky]

search for one of many back-end relinker apps - and adapt it to suit.

basically you drop connections to existing tables, then reconnect to tables in the new location.

 

[pr2-eugin]

This involves a bit of Coding.. Look closely to the MVP's site for information...

http://access.mvps.org/access/tables/tbl0009.htm