I'm not clear what you're trying to do. It sounds like you want all of the records from both tables. If that is the case, what you want is a union query.
Since both tables are identical, create a standard select query for one of the tables. Change to SQL view of that query and you'll see the select statement. Something like,
SELECT tbl1.fld1, tbl1.fld2 FROM tbl1;
I would start by removing all of the "tbl1." from the fields. You won't need them.
Copy all of the text (except the semicolon at the end).
Change the Query type to "SQL Specific>" "Union" (or simply type UNION before the semicolon).
Paste the copied text and replace the tbl1 with tbl2 in the FROM. This is why I recommended removing all the "tbl1.". If you didn't you have to change all of the "tbl1." with "tbl2.".
This will give you all the records from both tables in no particular order.
Save the query and you can treat that query as if it was a single table in your third database. If data is updated in either of the other databases your query will automatically pick up the change.
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org