Connect and query another access database. dev_joindb is a query def that must be defined first.

joindb.sql

SELECT dev_joindb.WHno, dev_joindb.Collar_Current_ID, geo.easting_x, geo.northing_y, geo.timestamp
FROM dev_joindb INNER JOIN [;database=C:\Users\Mgritts\Documents\Databases\dbase_capturemonitoringwarehouse\dbase_capturemonitoringwarehouse.accdb].tbl_gps_locations AS geo 
    ON dev_joindb.Collar_Current_ID = geo.deviceid;