Access database - file cannot be locked

  • Thread starter Thread starter Dorte
  • Start date Start date
D

Dorte

Hi,

This is probably an easy question, so I hope someone will
be able to help me, as I am a novice to connecting to
databases!

In ASP.NET I connect to an Access database - it seems that
the connection works ok (test connection returns ok), but
when I try to extract data, I get the error "File cannot
be locked". I have tried connecting from a windows
application and that works find, but something goes wrong
when connecting frow web.

Hope someone can help me, thanks.

Dorte
 
Dorte said:
In ASP.NET I connect to an Access database - it seems that
the connection works ok (test connection returns ok), but
when I try to extract data, I get the error "File cannot
be locked". I have tried connecting from a windows
application and that works find, but something goes wrong
when connecting frow web.
Click to expand...

be sure, the asp.net user has read/write permissions to the .mdb file
(ntfs file permissions).

hth
thoean
 
-----Original Message-----


be sure, the asp.net user has read/write permissions to the .mdb file
(ntfs file permissions).

hth
thoean

.
Click to expand...
I have already set the properties for the Access database -
I have granted the group "all" and "asp.net" all the
permissions possible - but I still get an error!
 
¤ Hi,
¤
¤ This is probably an easy question, so I hope someone will
¤ be able to help me, as I am a novice to connecting to
¤ databases!
¤
¤ In ASP.NET I connect to an Access database - it seems that
¤ the connection works ok (test connection returns ok), but
¤ when I try to extract data, I get the error "File cannot
¤ be locked". I have tried connecting from a windows
¤ application and that works find, but something goes wrong
¤ when connecting frow web.
¤

It's definitely a permissions issue with respect to the .LDB file. See if the following helps:

PRB: Cannot Connect to Access Database from ASP.NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;316675

INFO: Permissions to Connect to a Remote Access Database from ASP.NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;307901

If none of these solutions solve the problem I would use Filemon to troubleshoot the issue on your
web server:

http://www.sysinternals.com/ntw2k/source/filemon.shtml


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top