Error when using oledb to get to access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I use the OleDbDataProvider to get info from an access database I get
the following error:

The Microsoft Jet database engine cannot open the file 'C:\Documents and
Settings\bailedl1\Desktop\Dave's Docs\DemoData.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.

I have granted full control permission to the ISUR user with no results.
What do I need to do to solve this problem?

Thanks,

Dave
 
Hi Dave,

First, the flame: Don't use an Access database... Convert the database
to MSDE (You do know that MSDE is free, right?) and everything will be a
lot happier... ;-)

Seriously though... make sure that the file is not opened previously by
the aspnet worker process. If it is, restart your aspnet worker and it
should release any file locks on the database. Also, make sure that the
file isn't opened elsewhere. Also, in order for ASPNET to be able to
open the file, the ASPNET account (<MachineName>\ASPNET) needs to have
read AND write access to the folder that contains the database file (in
this instance, read/write access to your desktop).

HTH,
~d
 
Back
Top