How do I open access database with no lock?

  • Thread starter Andrew `Taersious` Coppock
  • Start date
A

Andrew `Taersious` Coppock

I am developing an Access database for use over the internet. When I try to
open the database locally, on the server, it locks out the internet account
totally, and causes a script error that says, "Error Type: Microsoft JET
Database Engine (0x80004005) Could not use ''; file already in use." When I
close Access and refresh the web page, the error goes away. I have already
set the default open mode to Shared, the default record locking to edited
record, but that does not help. Am I not going to be able to do this with
Access 2002?
 
R

Ron Hinds

"Andrew `Taersious` Coppock" <Andrew `Taersious`
[email protected]> wrote in message
I am developing an Access database for use over the internet. When I try to
open the database locally, on the server, it locks out the internet account
totally, and causes a script error that says, "Error Type: Microsoft JET
Database Engine (0x80004005) Could not use ''; file already in use." When I
close Access and refresh the web page, the error goes away. I have already
set the default open mode to Shared, the default record locking to edited
record, but that does not help. Am I not going to be able to do this with
Access 2002?
Click to expand...

I think the problem has to do with the permissions in the folder where your
Access database is stored. Specifically, the account that the webserver runs
under (usually IUSR_ServerName for IIS) needs to have full permissions in
that folder. What's happening is the webserver is unable to create/modify
the record locking (.LDB) file for the database. I'm guessing that if two
users of your website were in there simultaneously one of them would have
the same error.
 
Top