Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

johnzur@xxxxxxxxxxx wrote:
> Here's the entire error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> engine cannot open the file '\\15.40.4.241\NETDRIVE\incoming.mdb'. It
> is already opened exclusively by another user, or you need permission
> to view its data.
>
> I put in the IP address in the link because I access the database from
> other machines and if I use a drive letter I get an error when
> accessing
> via a networked drive. The links work fine when using a network
> drive.

Just to add to what Ray said (which is completely correct): all users of an
access databse must have read/write permissions for the folder containing
the database file, not just the file. This is because they need to be able
to create, modify and delete the database lock control file (dbname.ldb) in
order to allow multiuser activity. Without the lock file, only one user will
be able to connect to the database at a time.


Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages