You can join to an Access personal database table in a SELECT by using the OPENROWSET command. Here is an example to access the Orders table:

SELECT O.* FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'D:\MSOffice\Access\Samples\northwind.mdb';'LogIn';'PassWord', Orders) O