I developed many sites on a Win 2000 box, and recently was issued a XP Pro 

notebook. After I transferred my sites to the XP box and set up the DSN's, 

the pages no longer work. They either hang or I get the message

"

Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

[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.

"



What do I have to do in order for my Access databases to be accessable?

I have the same problem, am working off a remote DSN as a workaround. I 

hate to not offer any help, but I'd love to hear if anyone else has been 

able to solve this one.



best,



Ben



> I developed many sites on a Win 2000 box, and recently was issued a XP 

Pro 

> notebook. After I transferred my sites to the XP box and set up the 

DSN's, 

> the pages no longer work. They either hang or I get the message

> "

> Error Type:

> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

> [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.

> "

> 

> What do I have to do in order for my Access databases to be accessable?

What are the permissions on the .mdb file, and the folder that the .mdb file

is in?

Is the .mdb file on the local hard drive, or on the network?



Cheers

Ken



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

From: "Mike Frane" <mfrane@t...>

Subject: [access_asp] Access, ASP, and XP IIS





: I developed many sites on a Win 2000 box, and recently was issued a XP Pro

: notebook. After I transferred my sites to the XP box and set up the DSN's,

: the pages no longer work. They either hang or I get the message

: "

: Error Type:

: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

: [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.

: "



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

Hi: 



It's 3:46 AM, and I've finally solved this problem on my system. In order 

to develop locally the access permissions for the inetpub/wwwroot 

directory need to be set to other than their defaults (this is a change 

from 2000 I guess) in order to allow ASP pages that call a DSN to connect 

to a DB. In the Control Panel > Administrative tools > Internet 

Information Services thing, right click on the 'Web sites' folder and 

select the 'home directory' tab, then check read and write and change 

execute permissions to Scripts Only. This worked for me. 



***NOTE: I AM HAZY ON THE SECURITY IMPLICATIONS OF THIS, ALL CAVEATS 

APPLY, ETC.***



best,



Ben



> I developed many sites on a Win 2000 box, and recently was issued a XP 

Pro 

> notebook. After I transferred my sites to the XP box and set up the 

DSN's, 

> the pages no longer work. They either hang or I get the message

> "

> Error Type:

> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

> [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.

> "

> 

> What do I have to do in order for my Access databases to be accessable?

I changed the permissions for the files and then had to make a registry 

change, and it seems to be working now. It'd be nice when you install IIS 

on XP if they would let you know the major differences!



> What are the permissions on the .mdb file, and the folder that the .mdb 

file

> is in?

> Is the .mdb file on the local hard drive, or on the network?

> 

> Cheers

> Ken

> 

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> From: "Mike Frane" <mfrane@t...>

> Subject: [access_asp] Access, ASP, and XP IIS

> 

> 

> : I developed many sites on a Win 2000 box, and recently was issued a XP 

Pro

> : notebook. After I transferred my sites to the XP box and set up the 

DSN's,

> : the pages no longer work. They either hang or I get the message

> : "

> : Error Type:

> : Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

> : [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.

> : "

> 

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> 

I use XP extensively, and I haven't had to make any changes at all. If you

had NT or 2k before it all works exactly the same (the NTFS permissions that

is)



Cheers

Ken



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

From: "Mike Frane" <mfrane@t...>

Subject: [access_asp] Re: Access, ASP, and XP IIS





: I changed the permissions for the files and then had to make a registry

: change, and it seems to be working now. It'd be nice when you install IIS

: on XP if they would let you know the major differences!

:

: > What are the permissions on the .mdb file, and the folder that the .mdb

: file

: > is in?

: > Is the .mdb file on the local hard drive, or on the network?

: >

: > Cheers

: > Ken

: >

: > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

: > From: "Mike Frane" <mfrane@t...>

: > Subject: [access_asp] Access, ASP, and XP IIS

: >

: >

: > : I developed many sites on a Win 2000 box, and recently was issued a XP

: Pro

: > : notebook. After I transferred my sites to the XP box and set up the

: DSN's,

: > : the pages no longer work. They either hang or I get the message

: > : "

: > : Error Type:

: > : Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

: > : [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.

: > : "



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