-
Using a linked table in a query
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|