Switching Back End Databases on the fly

[Joe Williams]

Does anyone know of any good source to explain how to be able switch back
ends tables inside of a front end application? For instance, I would like
the user to be able to open a form where they could select the back end
database that they would like to use. This would allow them to have
different databases for testing, experiments, etc.

I have seen a few website that show how to do this through a large amount of
code, but none that specifically addressed making it so that the user could
switch the database on the fly.

Another cool option that I am trying to figure out how to do is allow the
user to click a button to create a blank database of thier choosing.

Can anyone help? THanks

- joe

 

[Douglas J. Steele]

Take a look at http://www.mvps.org/access/tables/tbl0009.htm at "The Access
Web"