Queries Using Tables from Other .mdbs

[ormsk]

I have an application in Access 2002 that 'accesses' data from other mdb's. I want to create a query that accesses tables from these mdbs.

The code exists in mdb (A) and I want to create an append query that appends from a table in mdb (B) into a table in mdb (C).

I can do this via recordsets, but I nned to achieve this via SQL.

**********************************
There is more than one way to skin a cat...but who wants a skinned cat?

 

[Ed2020]

Can't you just link the relevant tables from database B and database C into database A and then use them as if they were all in the same database?

Ed Metcalfe.

Please do not feed the trolls.....

 

[SkipVought]

...fact is you can LINK tables form all DIFFERENT kinds of database, if need be. Oracle, DB2, Excel -- it boggles the mind, like boneless chicken! ;-)

Skip,

_[red][/red]

 

[ormsk]

The problem is that the name and locations of the other mdb's are not constant (just the structure will be constant - table names etc).

The user selects these on the fly subject to the task in hand.



**********************************
There is more than one way to skin a cat...but who wants a skinned cat?

 

[SkipVought]

Are you saying that a database NAME and PATH keeps changing? How can ANYONE know where ANYTHING is?

OR...

are you saying that today Sam wants database 1/path 1 but tomorrow wants database 2/path 2? Databases never change names or locations. So you link BOTH!

Skip,

_[red][/red]

 

[ormsk]

Clients send in mdb's for testing (checking for missing records in a particular table)

They send in a 'corrupted' mdb along with a good known backup. My app allows user to browse through to both files, wherever they may be. The app then checks a prticular table (that exists in both mdbs) comparing ID's. When one is missing from the 'corrupted', there will be an option to restore that record from the good backup.

I want to use an append query to add back the missing record (as long as the ID exists in the good backup).

So the corrupted mdb and the good backup could be called something different each time (but the use of the browse, the app can connect to it).


**********************************
There is more than one way to skin a cat...but who wants a skinned cat?