Hi,



I'm having a problem where a user in another office cant view our project

intranet because of a permissions problem (I believe)



Error:





Microsoft JET Database Engine error '80004005' 



The Microsoft Jet database engine cannot open the file

'd:\inetpub\intranet\departments\emd\cp\Comms Projects\Project Web.mdb'. It

is already opened exclusively by another user, or you need permission to

view its data. 



/departments/emd/cp/Comms Projects/Hamlet/main.asp, line 50 



Line 50: 

conn.Open "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security

Info=False;Data Source=d:\inetpub\intranet\departments\emd\cp\Comms

Projects\project web.mdb;mode=share deny none;Jet OLEDB;"





I dont think its a "exclusive" problem as I can have many people have the

web site displayed.





I thought that Users dont have to have any permissions to the .mdb file at

all - this is opened by the server. The user only needs to have access to

the web pages that gather the information from the database and then display

it via http???



What is going wrong here? What am I missing?



Thanks for your help,

Philip Ware.

The IUSR_<machinename> account needs NTFS Read/Write/Delete permissions to

both the actual Access .mdb file (for obvious reasons) and also to the

folder that the file is in (to be able to create and destroy the Access .ldb

lockfile that is created).



If it doesn't have permission to delete the lockfile then you can have

problems with the next user that tries to open the database...



Also, make sure you haven't got the database open in Access, or via InterDev

etc as well.



Cheers

Ken

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

From: "Philip.Ware" <Philip.Ware@e...>

To: "ASP Databases" <asp_databases@p...>

Sent: Tuesday, November 21, 2000 9:18 PM

Subject: [asp_databases] Asp Error: 80004005





> Hi,

>

> I'm having a problem where a user in another office cant view our project

> intranet because of a permissions problem (I believe)

>

> Error:

>

>

> Microsoft JET Database Engine error '80004005'

>

> The Microsoft Jet database engine cannot open the file

> 'd:\inetpub\intranet\departments\emd\cp\Comms Projects\Project Web.mdb'.

It

> is already opened exclusively by another user, or you need permission to

> view its data.

>

> /departments/emd/cp/Comms Projects/Hamlet/main.asp, line 50

>

> Line 50:

> conn.Open "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security

> Info=False;Data Source=d:\inetpub\intranet\departments\emd\cp\Comms

> Projects\project web.mdb;mode=share deny none;Jet OLEDB;"

>

>

> I dont think its a "exclusive" problem as I can have many people have the

> web site displayed.

>

>

> I thought that Users dont have to have any permissions to the .mdb file at

> all - this is opened by the server. The user only needs to have access to

> the web pages that gather the information from the database and then

display

> it via http???

>

> What is going wrong here? What am I missing?

>

> Thanks for your help,

> Philip Ware.

>