Error # = 80004005
Description = [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '\ServernameDatabaseADDRESSES.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = S1000
NativeError = -1032

My code:
MyDb.DbDSN="USARC2000"
MyDb.DbSQL ="Select * FROM myQuery"

myQuery has local tables plus a linked table from another database. If I import the table to the current database, there is no error. However, importing the table is not an option. It should remain linked.

Can I place two DSNs in the code, so that the linked table is recognized?

Or is there another workaround?