Hi,

Please can you help. I need to access an access 2000 format database over 
a network, that is on a seperate machine from that running IIS.

Presently, on connecting to the database, I get the following error:
---------------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Microsoft][ODBC Microsoft Access 97 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. 

/scripts/somefile.asp, line x 
---------------------------------------------------------------

Please can you advise the permissions that require setting up for me to 
achieve this. The ASP file that accesses the database is set to not allow 
anonymous access.

Thanks in advance,
Michael

This is a multi-part message in MIME format.

------=_NextPart_000_0217_01C1FC19.725B42D0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Read the error again Michael you have an access 97 ODBC driver trying to 
open an access 2000 database. You need to upgrade your odbc to 200



Kind Regards

Patrick A Ames (PALM Computing)

PALM Computing
Completed Internet Solutions
Hosting On NT Servers, Domain Registration
ISP, Web Design, ASP Scripting, Bespoke Services
ETRN/SMTP Mail System, POP3 System
Online Live Stats

www.palminternetservices.biz
www.australasianinternetservices.biz
www.australasianinternetservices.com
www.palmcomputingau.com
www.palmcomputingoz.com


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.361 / Virus Database: 199 - Release Date: 08/05/2002

Apologies, I posted the incorrect error message, I ripped that one down 
from the MS site where I was looking for a solution!

The actual message I get is as follows:

------------------------------------------------------------------------
Microsoft JET Database Engine error '80004005' 

The Microsoft Jet database engine cannot open the 
file '\\machinename\dbpath'. It is already opened exclusively by another 
user, or you need permission to view its data. 
------------------------------------------------------------------------

> Hi,

> Please can you help. I need to access an access 2000 format database 
over 
a>  network, that is on a seperate machine from that running IIS.

> Presently, on connecting to the database, I get the following error:
-> --------------------------------------------------------------
M> icrosoft OLE DB Provider for ODBC Drivers error '80004005' 

> [Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database 
e> ngine cannot open the file '(unknown)'. It is already opened 
exclusively 
b> y another user, or you need permission to view its data. 

> /scripts/somefile.asp, line x 
-> --------------------------------------------------------------

> Please can you advise the permissions that require setting up for me to 
a> chieve this. The ASP file that accesses the database is set to not 
allow 
a> nonymous access.

> Thanks in advance,
M> ichael

This is a multi-part message in MIME format.

------=_NextPart_000_0245_01C1FC2C.B04A1450
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Ok No problem
Go to the machine where the database is and locate the mdb file
right click and select properties
click on security tab
make sure the boix on the bottom left that says inherit is ticked and 
make sure you allow full access to it




Kind Regards

Patrick A Ames (PALM Computing)

PALM Computing
Completed Internet Solutions
Hosting On NT Servers, Domain Registration
ISP, Web Design, ASP Scripting, Bespoke Services
ETRN/SMTP Mail System, POP3 System
Online Live Stats

www.palminternetservices.biz
www.australasianinternetservices.biz
www.australasianinternetservices.com
www.palmcomputingau.com
www.palmcomputingoz.com


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.361 / Virus Database: 199 - Release Date: 08/05/2002

Make sure you have modify/write access for the IUSR_YourServerName account on both the directory the
Access file is located in and on the Access file itself
=2E

Tony Wilko
tony@i...=2Ecom

----- Original Message -----
From: Michael Bell
Sent: 5/15/2002 10:01:34 AM
To: asptoday_discuss@p...=2Ewrox=2Ecom
Subject: [asptoday_discuss] Re: Accessing an access database that is not on the same machine as II
S

> Apologies, I posted the incorrect error message, I ripped that one down

> from the MS site where I was looking for a solution!

>

> The actual message I get is as follows:

>

> ------------------------------------------------------------------------

> Microsoft JET Database Engine error '80004005'

>

> The Microsoft Jet database engine cannot open the

> file '\\machinename\dbpath'=2E It is already opened exclusively by another


> user, or you need permission to view its data=2E

> ------------------------------------------------------------------------

>

> > Hi,

>

> > Please can you help=2E I need to access an access 2000 format database

> over

> a>  network, that is on a seperate machine from that running IIS=2E

>

> > Presently, on connecting to the database, I get the following error:

> -> --------------------------------------------------------------

> M> icrosoft OLE DB Provider for ODBC Drivers error '80004005'

>

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

> e> ngine cannot open the file '(unknown)'=2E It is already opened

> exclusively

> b> y another user, or you need permission to view its data=2E

>

> > /scripts/somefile=2Easp, line x

> -> --------------------------------------------------------------

>

> > Please can you advise the permissions that require setting up for me to

> a> chieve this=2E The ASP file that accesses the database is set to not

> allow

> a> nonymous access=2E

>

> > Thanks in advance,

> M> ichael

>

>

>