Procedure to Remap Tables

[NeilGel]

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

 

[tina]

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

 

[Roger Carlson]

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/wa.exe?SUBED1=ACCESS-L