Error Message

5 May 2006 11:17 PM

Joe Delphi

Hi,

          I am writing an ASP.NET 1.1 application that connects to a
Microsoft Access database using the OleDB data controls.    I keep getting
this error
message:

"The Microsoft Jet database engine cannot open the file 'C:\MyDatabase.mdb'.
It is already opened exclusively by another user, or you need permission to
view its data."

          The database is on my local machine and does not appear to be
open, so I cannot figure why I am getting this message. Also, the user
under which the web app is running has Administrator permissions.
Re-booting my machine has no effect.

    Can anyone tell me the cause of this message and how to avoid it?

JD

6 May 2006 12:14 PM

Cowboy (Gregory A. Beamer)

It is very often a permissions issue. Make sure the account the web app is
running under, generally IUSR_ComputerName (where ComputerName is the name
of your computer), has both read and write access to the directory and file.

In order to open an Access file, you have to have permissions to write the
lock file. If the account does not have the ability to write the lock file,
it will fail.

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************

"Joe Delphi" <delphi561@nospam.cox.net> wrote in message

news:X1R6g.18184$Qz.5003@fed1read11...
Show quote

> Hi,
>
>          I am writing an ASP.NET 1.1 application that connects to a
> Microsoft Access database using the OleDB data controls.    I keep getting
> this error
> message:
>
> "The Microsoft Jet database engine cannot open the file
> 'C:\MyDatabase.mdb'.
> It is already opened exclusively by another user, or you need permission
> to
> view its data."
>
>          The database is on my local machine and does not appear to be
> open, so I cannot figure why I am getting this message. Also, the user
> under which the web app is running has Administrator permissions.
> Re-booting my machine has no effect.
>
>    Can anyone tell me the cause of this message and how to avoid it?
>
> JD
>
>

6 May 2006 4:53 PM

Joe Delphi

Yes, you were right. I moved the folder containing my MS Access database to
the Shared Folders part of my file system and then everything started
working as normal.

Thank you,
JD

Show quote

"Cowboy (Gregory A. Beamer)" <NoSpamMgbworld@comcast.netNoSpamM> wrote in
message news:O3qFlaQcGHA.2068@TK2MSFTNGP02.phx.gbl...
> It is very often a permissions issue. Make sure the account the web app is
> running under, generally IUSR_ComputerName (where ComputerName is the name
> of your computer), has both read and write access to the directory and
file.
>
> In order to open an Access file, you have to have permissions to write the
> lock file. If the account does not have the ability to write the lock
file,
> it will fail.
>
> --
> Gregory A. Beamer