How do I open access database with no lock?

[Guest]

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?

 

[Ron Hinds]

"Andrew `Taersious` Coppock" <Andrew `Taersious`
(e-mail address removed)> 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?

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.