Hi when I run a script to open a access database on a iis4 server I get the 

following error;

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.



This script runs fine on another server, Could someone tell me what this 

could be to get the administrator to fix this?



Thanks

I was getting this same error on my computer.  I tried changing 

permissions, adding users, etc. but couldn't get it to work.  I ended up 

copying the tables to a new database and it worked fine for me.  I'd still 

like to know what the problem was though...



Shawn





On 05/04/00, "Carl Dickson" wrote:

> Hi when I run a script to open a access database on a iis4 server I get the

following error;

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.



This script runs fine on another server, Could someone tell me what this 

could be to get the administrator to fix this?



Thanks

It usually means that the database is open in design mode or someone locked

it



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

From: 	Carl Dickson 

Sent:	Thursday, May 04, 2000 5:33 PM

To:	ASP Databases

Subject:	[asp_databases] Openining a database



Hi when I run a script to open a access database on a iis4 server I get the

following error;

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.



This script runs fine on another server, Could someone tell me what this

could be to get the administrator to fix this?



Thanks



---

You are currently subscribed to asp_databases

Carl,



I assume the database is on another machine as this is the error message

produced when the IIS server tries to use an Access DB across the network

using the IUSER_machine name account.  This account is local to the IIS

server and doesn't have network access rights and therefore fails due to

permission problems.



The only way I have found around this is to have the Access DB on the IIS

Server.



Rgds



Pip



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

From: Carl Dickson 

Sent: 04 May 2000 17:33

To: ASP Databases

Subject: [asp_databases] Openining a database





Hi when I run a script to open a access database on a iis4 server I get the 

following error;

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.



This script runs fine on another server, Could someone tell me what this 

could be to get the administrator to fix this?



Thanks



---

You are currently subscribed to asp_databases 

Make sure the IUSR_Computername account has at least read, write, delete

permissions to both the file and the folder that the file is in



You need this so that the anonymous user can alter the database, but also so

that it can create the .ldb lockfile in the folder, and delete it later on.



(this is all assuming that no one has the database open interactively in

exclusive mode on the server...)



Cheers

Ken

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

From: "Carl Dickson" 

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

Sent: Thursday, May 04, 2000 5:32 PM

Subject: [asp_databases] Openining a database





> Hi when I run a script to open a access database on a iis4 server I get

the

> following error;

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

>

> This script runs fine on another server, Could someone tell me what this

> could be to get the administrator to fix this?

>

> Thanks

>

Carl

I am sure this is an IUSR_machine permissions problem. Try reading 'ASP 

Troubleshooting Tips and Techniques' in MSDN. There are also several 

Knowledgebase articles on this topic. I think you will need the mdb on the 

IIS server.



Willie

On 05/04/00, "Carl Dickson" wrote:

> Hi when I run a script to open a access database on a iis4 server I get the

following error;

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.



This script runs fine on another server, Could someone tell me what this 

could be to get the administrator to fix this?



Thanks

Hi, yes the mdb file is on the server, I ment when all files are loaded on

another server it works. I look into the permissions solution.



Thanks



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

From: William Milne 

Sent: 05 May 2000 00:00

To: ASP Databases

Subject: [asp_databases] Re: Openining a database





Carl

I am sure this is an IUSR_machine permissions problem. Try reading 'ASP

Troubleshooting Tips and Techniques' in MSDN. There are also several

Knowledgebase articles on this topic. I think you will need the mdb on the

IIS server.



Willie

On 05/04/00, "Carl Dickson" wrote:

> Hi when I run a script to open a access database on a iis4 server I get

the

following error;

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.



This script runs fine on another server, Could someone tell me what this

could be to get the administrator to fix this?



Thanks



---

You are currently subscribed to asp_databases