One front end, multiple database files (1 Viewer)

[CJKCyclone]

We have software that has an Access front-end talking to a separate access database file. Is there a way I can make the front-end file ask me which Access database I'd like to connect to at start-up?

To clarify, I want a one to many relationship between the front-end and the database. I realize I can't have concurrent connections, but just having the ability to choose which database I want at the beginning of the session would suffice.

Obviously some linking of tables must occur and I'd like to know if that can also be automated.

Any help would be greatly appreciated. TIA

 

[CJKCyclone]

Bueller?...Bueller?...Bueller?

Anyone?...Anyone?

 

[Fizzio]

There is an example of refreshing links in the microsoft Northwind sample Db but this thread may give you inspiration

http://www.access-programmers.co.uk...eadid=27824&highlight=refresh+link+on+startup

You should be able to modify the dbCurrent to change according to a user input / selection.