VBA to switch "back ends"

Hi all,

I have a rather large split database, when developing code I obviously have to be extremely careful not to affect the live data so I have a test version locally however this involves creating and testing in the test version then exporting the relevant changes to the live.

What Id like to do is have the ability to switch the backend links via an option in an admin area so maybe a button to switch from live data to test version.

This would then break the existing table links and create the new links to the alterantive version, allowing me to develop and test in the live front end without fear of breaking anything (it would also allow us to have a training version available to new staff).

Can anyone give me an hints towards how to do this? is there a few lines of VBA to do it or do I have to code in the deletion of all linked tables and then re-link them to version b?

Also however, can anyone see any downsides to this approach that I might have missed?

I have a form with a combo box, hooked to a table that has the paths to prod and test dbs.
It shows TEST, or PROD.
[DB], [PATH]
TEST, test db path...
PROD, production db path...

User picks the db, clicks CONNECT button ,then the code resets the paths to the tables...
ReLinkDB cboBox

Please Login or Register  to view this content.