MDB linked to MDB

[Rhuel Adona]

Hi,

I would like to ask a question if there is a way to get information from another database using macros, vba or modules.

Here is the sample scenario

There are two database, A and B respectively.
Is it possible for database A to get records from a table in database B. The analogy is like linking a table from database A with a table from database B given a column to be linked. (Is it also possible to use SQL in these kind of select statement)

Thanks
Rhoy

 

[Travis]

Yes, By simply linking the tables to the current db file that you are in. Assuming that you are in DB "B", just link it to the table in DB "A" then create any queries as you would normally do. (The wonderfull world of Relational DB).