Linking Databases

[KingRudeDog]

Hey all!

Okay, so here's a real puzzle, so put on yur thinking caps!

I have two large databases that are twins of eachother, with only a minor difference in a small corner of one table. Even the forms are exactly the same.

I want to split each one from thier tables, so I have databases strictly for [tables], and strictly [forms, queries and reports]...

Then I would like to get rid of one of the copy cat [forms, queries and reports] db's leaving a single [f,q and rpts] db with the ability of ANY user (not a semi-skilled db dev such as me) to have the option at opening, which db to link to for the tables (without going into the tool bar, since it is not visible to them).

Is there an EASY way for a "non-dev" user to choose which [tables db] on an opening form/switchboard?

Live long....prosper.

 

[KeithG]

I would link all the tables to this database then have a form where the user choose which table is the record source and then change the record source behind the form/report to match there selection.

 

[KingRudeDog]

Problem...

remember that the db's are twins. That means that with the exception of the data in a single table, everything else is the same, even the table names.

Therefore the problem lies.

I can't have re-occurring table names linked at the same time with all the same relationships. I could change the table names, but this db is quite massive, and that would entail more work than would be worth the time.

Thanks for the quick reply though.

Any other ideas?

 

[KeithG]

What about using pass through queries (ODBC driver) to get the info into the database instead of linking. Then change the recordsource of the form/report to the corret pass through query that contains the data the user needs.