Hi Andrew,
Yep, you can do this easily.
(You in fact 'link' to the other table, which can then be accessed as if it was a real table in your current db).
Goto TABLES, click NEW, then click the LINK TABLE button (this all depends on your Access version, but similar if not identical). Use the supplied Explorer to find the db which holds the table that you want, open it, select the table you want then click OK.
You now have a 'link table' in your current database.
It's obvious as a 'link' because of the black arrow to its left.
This is not a copy of the table, the link just REFERS to the table in the other DB.
Remember that 'copying' a link table for back-up purposes DOES NOT copy the table - it just copies the link reference.
(If I copied MYLINK1 link to MYLINK2 and made changes to MYLINK1 then on opening MYLINK2 - I would see those changes).
Regards,
Darrylle
"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."