Hi! I'm getting this message viewing my page



Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine 

cannot open the file '(unknown)'. It is already opened exclusively by 

another user, or you need permission to view its data.



The error is at the line where i try to open the connection... i don't do 

any update to the database and i'm sure that the access file is only view by 

me

i'm looking foward for help... thenks!

Is this the most FAQed thing on the list?



99.9% of the time this means you have the database open by someone else...

In all likelihood you have the database open in Access itself. 



You can't do that.



Hal Levy

StarMedia Network, Inc.

Intranet Development Manager 



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

> From: COCO LUA SUAT CHOO [mailto:cocolua@h...]

> Sent: Thursday, July 19, 2001 6:06 AM

> To: ASP Database Setup

> Subject: [asp_database_setup] Drivers Error "80004005"

> 

> 

> Hi! I'm getting this message viewing my page

> 

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

> [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet 

> database engine 

> cannot open the file '(unknown)'. It is already opened exclusively by 

> another user, or you need permission to view its data.

> 

> The error is at the line where i try to open the 

> connection... i don't do 

> any update to the database and i'm sure that the access file 

> is only view by 

> me

> i'm looking foward for help... thenks!

> 

> 

I was going to write a FAQ on 80004005, but there are soooo many causes (and

so many different error messages), that I gave up...(and you can't explain

some things to some people...)



But if anyone has a collection of 80004005 error messages that they can send

me, I'll start again :-)



Cheers

Ken



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

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

From: "Hal Levy" <hal.levy@s...>

To: "ASP Database Setup" <asp_database_setup@p...>

Sent: Thursday, July 19, 2001 10:02 PM

Subject: [asp_database_setup] RE: Drivers Error "80004005"





: Is this the most FAQed thing on the list?

:

: 99.9% of the time this means you have the database open by someone else...

: In all likelihood you have the database open in Access itself.

:

: You can't do that.

:

: Hal Levy

: StarMedia Network, Inc.

: Intranet Development Manager

:

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

: > From: COCO LUA SUAT CHOO [mailto:cocolua@h...]

: > Sent: Thursday, July 19, 2001 6:06 AM

: > To: ASP Database Setup

: > Subject: [asp_database_setup] Drivers Error "80004005"

: >

: >

: > Hi! I'm getting this message viewing my page

: >

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

: > [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet

: > database engine

: > cannot open the file '(unknown)'. It is already opened exclusively by

: > another user, or you need permission to view its data.

: >

: > The error is at the line where i try to open the

: > connection... i don't do

: > any update to the database and i'm sure that the access file

: > is only view by

: > me

Make sure that the IUSR_<machinename> account has sufficient permissions to

*delete* the .ldb lockfile that it creates. Otherwise, when you next open a

connection, the database will still be locked.

Make sure you open the connections as late as possible, and you close them

as soon as possible



Cheers

Ken



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

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

From: "COCO LUA SUAT CHOO" <cocolua@h...>

To: "ASP Database Setup" <asp_database_setup@p...>

Sent: Thursday, July 19, 2001 8:06 PM

Subject: [asp_database_setup] Drivers Error "80004005"





: Hi! I'm getting this message viewing my page

:

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

: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database

engine

: cannot open the file '(unknown)'. It is already opened exclusively by

: another user, or you need permission to view its data.

:

: The error is at the line where i try to open the connection... i don't do

: any update to the database and i'm sure that the access file is only view

by

: me

: i'm looking foward for help... thenks!

:

:

: ---

: Search the best ASP Web sites using CodeHound! http://www.codehound.com

: Now it's easy to find ASP source code on the Internet. CodeHound's free

: search engine will categorize your results and even search for ASP code

: compressed in Zip files on the Internet.  Stop searching dozens of

: different sites to find what you want...try CodeHound right now!



ken@a...


$subst('Email.Unsub')