Table join between two tables in different databases
Attaching table using Access does NOT copy the attached table to the
database. It simply creates a pointer to the table data in the source
database.
Quote:
>How can I create a dynaset which recordset is a join between two tables
>stored in different Access database (*.MDB)?
>What I can think of is to attach an external tables into another database,
>but it seems that it will actually copy the whole table to the database. It
>is not desirable as the table is quite large.
>Any other suggestions?
>Thanks in advance.
>Derek Kung
