If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Procedure to Remap Tables
Hi,
I have a database which is operating in a production environment. There are around 6 backends, I want to set up a replicated development environment. This should be fairly easy, a bit of work but easy enough. Ideally when I publish new releases the the production environment, I'd like to just be able to switch a flag which would re-point all my front end, back end links to the production backends. Anyone know a way of doing this, or any previous lessons any doing this. Any help would be appreciated. Cheers Neil |
#2
|
|||
|
|||
Procedure to Remap Tables
you could add a table to the frontend db, with one record for each filepath
to each backend db. if the "production" backend dbs are all in the same folder, and the "development" backends are also in one folder, then you could get by with two records in the table - one record for each filepath. add a second field to designate each record as "production" or "development". then just add a public module to delete all the linked tables, and then re-link them, pulling the filepath from the table according to whether you want a production link or a development link. hth "NeilGel" wrote in message ... Hi, I have a database which is operating in a production environment. There are around 6 backends, I want to set up a replicated development environment. This should be fairly easy, a bit of work but easy enough. Ideally when I publish new releases the the production environment, I'd like to just be able to switch a flag which would re-point all my front end, back end links to the production backends. Anyone know a way of doing this, or any previous lessons any doing this. Any help would be appreciated. Cheers Neil |
#3
|
|||
|
|||
Procedure to Remap Tables
On my website (www.rogersaccesslibrary.com), are two small Access database
samples called "LinkTables.mdb" and "RelinkOnOpen.mdb" which should get you started. -- --Roger Carlson MS Access MVP Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? Free subscription: http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L "NeilGel" wrote in message ... Hi, I have a database which is operating in a production environment. There are around 6 backends, I want to set up a replicated development environment. This should be fairly easy, a bit of work but easy enough. Ideally when I publish new releases the the production environment, I'd like to just be able to switch a flag which would re-point all my front end, back end links to the production backends. Anyone know a way of doing this, or any previous lessons any doing this. Any help would be appreciated. Cheers Neil |
Thread Tools | |
Display Modes | |
|
|