Change database where data is stored with a dropdown box

[le_carrington]

The company wants to open a database that has the forms reports queries in it and using code behind a dropdown box pick which project the tables come from. This is project management software and each project is stored seperately. Since one engineer could work on several projects they want to switch to a new project and relink the tables without having to open up a new database. i.e. Database one has the forms, queries and reports. Database 2 and 3 are for project 1 and project 2 and contain only the tables. Can I point Database 1 at the first one and then switch and point it at the second one?

[RuralGuy]

The simple answer is yes. Switching BackEnds is not particularly difficult but does require the use of code.

[le_carrington]

The simple answer is yes. Switching BackEnds is not particularly difficult but does require the use of code.

Any Idea where I can find a nice piece of code

[RuralGuy]

Here's a link you might find useful: http://www.mvps.org/access/tables/tbl0009.htm

[le_carrington]

Thank you - I do appreciate it. I am usually quite good with doing things in Access but I hadn't done that before.

[RuralGuy]

Let us know if you need further assistance. We'll be here.