I don't see enough to know for sure and I don't have time to test tonight
but try something like this. I might have your DB's and or columns mixed up.
Select MRP.Item, MRP.Desc
JOIN IMAST IN 'P:\Chicago\Production\Masterdb.mdb' ON
(MRP.Item = INMAST.Item)
The connection string opens Plant2.mdb
Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]