Error Message

  • Thread starter Thread starter Joe Delphi
  • Start date Start date
J

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
 
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!
*************************************************
 
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
 
Back
Top