Choose between test and live back end files

[glawson]

Hi,

I have a split accdb in Access 2010 with tables/data in the back end file (stored on a network drive) and the forms, queries and code in a front end file stored on each desktop. Note the front end file is common to two back end files. Both back ends will be mirrored but I need to use one for live data and the other for development and testing.

I want to be able to include vba code when the front end is launched that prompts the user to choose between one of two back end files, one 'test' and the other 'live'. But I've spent all afternoon scouring the net with no success on something simple but effective.

Can someone assist me with code that will do the following automatically please?

As I see it I just need an option on a form and depending on which is selected the following happens:

- links to current/existing tables are deleted
- chosen back end file (test or live) is selected (this has a password)
- links to the tables of the chosen file are created in the front end
- the appropriate back end source is now working with my front end

Help much appreciated.

 

[Cronk]

Had you searched this site, you would have got, together with others, this thread

http://www.access-programmers.co.uk/forums/showthread.php?t=273356&highlight=relinking+tables

You might also want to change the colour of the form to indicate which back end is linked to so that users don't forget where they are.