Error Message

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

Cowboy
Sat May 06 07:14:38 CDT 2006

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...
> 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
>
>

Joe
Sat May 06 11:53:32 CDT 2006

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



"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