-
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?
-
Using a linked table in a query (reply)
It is exactly like what is says. Somebody is using it like locking it for editing etc. If you try to use ACCESS as a read/write web database, you already lost before you started. Upgrade to SQL or just import a copy of the mdb to your location.
FK
------------
karen at 4/18/00 10:04:54 AM
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?
-
Using a linked table in a query (reply)
Hi Karen,
You might try upgrading to ADO 2.1. That fixes things like that.
Good luck.
Donna
------------
karen at 4/18/00 10:04:54 AM
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
|
|