Re: Can't query linked Access database specified by UNC
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 01/18/05
- Next message: Vadim Rapp: "Re: Can't query linked Access database specified by UNC"
- Previous message: Sue Hoegemeier: "Re: Accidentally dropped DBO from database"
- In reply to: Vadim Rapp: "Can't query linked Access database specified by UNC"
- Next in thread: Vadim Rapp: "Re: Can't query linked Access database specified by UNC"
- Reply: Vadim Rapp: "Re: Can't query linked Access database specified by UNC"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 18 Jan 2005 13:23:38 -0700
The first is to do is ensure that the database is not being
opened exclusively by other users. If that's all fine then
the error is likely related to permissions.
The account accessing the database needs a minimum of
something similar to Create, Destroy, Read, Write (depending
on the OS) on the folder where the mdb and ldb lives so it
can work with the .ldb file. Those are the minimum
permissions needed in general but it depends upon what
version of Access, what version of MDAC, what OS.
If the permissions are correct, you need to drill down
further to the access control and make sure that the account
has change permissions on the folder where the ldb file
resides. Make sure these are correct by explicitly setting
the permissions for the account.
I've seen several places just use a specific folder for just
the mdb (and consequently the ldb) and give the account full
control over that folder to make things less convoluted in
terms of permissions and the requirement for the ldb file.
-Sue
On Mon, 17 Jan 2005 13:35:38 -0600, "Vadim Rapp"
<vrapp@nospam.polyscience.com> wrote:
>Hello,
>
>I link Access database to sql server 2000 with ole db 4 provider; tell it to
>logon with username ADMIN, empty password.
>
>If the database is on a local drive, everything works correctly, I see the
>tables of the access database in EM, and I successfully run query like
>select * from accessdb...table1
>
>If the database is on a remote drive and is specified by UNC, I still see
>the tables in EM when EM runs on the server; but when I run EM on another
>machine, focusing the tables under the linked server returns error
>0x80004005. Same when I try to run a query (even on the server):
>
>OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
>[OLE/DB provider returned message: The Microsoft Jet database engine cannot
>open the file '\\server\share\accessdb.mdb'. It is already opened
>exclusively by another user, or you need permission to view its data.]
>OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
>IDBInitialize::Initialize returned 0x80004005: ].
>
>Sql server is running on domain administrative account. At the same time as
>the message is issued, I can log on that account on the server, launch
>Access, and successfully open that same remote database using the same UNC
>path.
>
>What gives?
>
>
>thanks,
>
>Vadim Rapp
>Polyscience, Inc.
- Next message: Vadim Rapp: "Re: Can't query linked Access database specified by UNC"
- Previous message: Sue Hoegemeier: "Re: Accidentally dropped DBO from database"
- In reply to: Vadim Rapp: "Can't query linked Access database specified by UNC"
- Next in thread: Vadim Rapp: "Re: Can't query linked Access database specified by UNC"
- Reply: Vadim Rapp: "Re: Can't query linked Access database specified by UNC"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
