Okay,

This is the error I'm getting:



Microsoft OLE DB Provider for ODBC Drivers error '80004005' 



[Microsoft][ODBC Microsoft Access Driver] Could not lock file. 



/thepcigroup/login/securityloginforward.asp, line 13



Line 13 in that file is the "objConn.open "DSN=PWDB""



I don't have any problems with this when I am running the pages on my computer, but when 

I 

upload the pages to the server I have problems.  I've checked the access database security 

and there shouldn't be any problems with that.  I can't think of what else might be wrong.  I 

could use some help.  Thanks.



Matt

Check that the IUSR_xxxx account has create/delete privs on the *directory*

where the .mdf resides. It needs to create/delete the lock (.ldb) file.



-- Tomm



> -----Original Message-----

> From: Matt Sherman [mailto:mrpeanut1@j...]

> Sent: Tuesday, October 09, 2001 3:52 PM

> To: ASP Databases

> Subject: [asp_databases] error 80004005 Could Not Lock File...

>

>

> Okay,

> This is the error I'm getting:

>

> Microsoft OLE DB Provider for ODBC Drivers error '80004005'

>

> [Microsoft][ODBC Microsoft Access Driver] Could not lock file.

>

> /thepcigroup/login/securityloginforward.asp, line 13

>

> Line 13 in that file is the "objConn.open "DSN=PWDB""

>

> I don't have any problems with this when I am running the pages on

> my computer, but when

> I

> upload the pages to the server I have problems.  I've checked the

> access database security

> and there shouldn't be any problems with that.  I can't think of

> what else might be wrong.  I

> could use some help.  Thanks.

>

> Matt

Okay,

I'm sorry, but I need a little more specifics than that.  I'm used to 

using dBase databases, you just upload those, create a DSN and they work.  

What is the IUSR_xxxx?  And how do I check to see if it has 

created/deleted privs on the *directory*?  I just need a little bit more 

specific instructions.  Thanks.



Matt S.

 

> Check that the IUSR_xxxx account has create/delete privs on the 

*directory*

> where the .mdf resides. It needs to create/delete the lock (.ldb) file.

> 

> -- Tomm

> 

The IUSR_xxx account is the account the anon web user  is seen as on the

server machine. Under NT, you have to give that user the permission to

create/delete files in that directory... that account doesn't have them by

default.



-- Tomm



> -----Original Message-----

> From: Matt Sherman [mailto:mrpeanut1@j...]

> Sent: Tuesday, October 09, 2001 5:41 PM

> To: ASP Databases

> Subject: [asp_databases] RE: error 80004005 Could Not Lock File...

>

>

> Okay,

> I'm sorry, but I need a little more specifics than that.  I'm used to

> using dBase databases, you just upload those, create a DSN and they work.

> What is the IUSR_xxxx?  And how do I check to see if it has

> created/deleted privs on the *directory*?  I just need a little bit more

> specific instructions.  Thanks.

>

> Matt S.

>

> > Check that the IUSR_xxxx account has create/delete privs on the

> *directory*

> > where the .mdf resides. It needs to create/delete the lock (.ldb) file.

> >

> > -- Tomm

IUSR_xxxx (the xxxx is your machine name which may be something intelligable

like PORKPIE or may be rather cryptic like DKFAF9E) is a user account in the

NT domain or Active directory or on your web server box.  The web server

software performs most of its actions as if it were logged in as this user.



When you put a myaccessdb.mdb file somewhere and open it, access creates a

myaccessdb.ldb file in the same dir.  Since this is to be done be the

webserver, the user IUSR_xxxx needs to be able to write the .ldb file, so it

needs write permisssion to the directory where the .mdb lies.



HTH





> -----Original Message-----

> From: Matt Sherman [mailto:mrpeanut1@j...]

> Sent: 09 October 2001 18:41

> To: ASP Databases

> Subject: [asp_databases] RE: error 80004005 Could Not Lock File...

> 

> 

> Okay,

> I'm sorry, but I need a little more specifics than that.  I'm used to 

> using dBase databases, you just upload those, create a DSN 

> and they work.  

> What is the IUSR_xxxx?  And how do I check to see if it has 

> created/deleted privs on the *directory*?  I just need a 

> little bit more 

> specific instructions.  Thanks.

> 

> Matt S.

>  

> > Check that the IUSR_xxxx account has create/delete privs on the 

> *directory*

> > where the .mdf resides. It needs to create/delete the lock 

> (.ldb) file.

> > 

> > -- Tomm

Bring up the properties page of the directory that the db is located in.



Click on the security tab

Add the user IUSR_<computername> wheree <computername> is the netbios

name of that server system

Give that user read write execute permissions.

Click apply and ok

You should be set. 



daniel



--------------------------

Daniel O'Dorisio

daniel@o...

www.odorisio-networks.com

--------------------------



-----Original Message-----

From: Matt Sherman [mailto:mrpeanut1@j...] 

Sent: Tuesday, October 09, 2001 5:41 PM

To: ASP Databases

Subject: [asp_databases] RE: error 80004005 Could Not Lock File...





Okay,

I'm sorry, but I need a little more specifics than that.  I'm used to 

using dBase databases, you just upload those, create a DSN and they

work.  

What is the IUSR_xxxx?  And how do I check to see if it has 

created/deleted privs on the *directory*?  I just need a little bit more



specific instructions.  Thanks.



Matt S.

 

> Check that the IUSR_xxxx account has create/delete privs on the

*directory*

> where the .mdf resides. It needs to create/delete the lock (.ldb) 

> file.

> 

> -- Tomm

Possibly the IUSR_<machinename> account on the remote machine doesn't have

permissions to delete the .ldb file, or to create the .ldb file in the first

place. The .ldb file is the locking file that Jet uses to maintain and track

locks on the database. This is an NTFS permissions problem.



Another possibility is that your code is such that you are maintaining a

lock on something whilst trying to get a lock on that same object (eg users

could be causing contention, or code within a single page being browsed by

one user is causing contention).



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Matt Sherman" <mrpeanut1@j...>

Subject: [asp_databases] error 80004005 Could Not Lock File...





: Okay,

: This is the error I'm getting:

:

: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

:

: [Microsoft][ODBC Microsoft Access Driver] Could not lock file.

:

: /thepcigroup/login/securityloginforward.asp, line 13

:

: Line 13 in that file is the "objConn.open "DSN=PWDB""



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~