All, can someone tell me if their is a way to establish a connection to a

Access 97 db

with the correct permissions....? below is the error I am receiving and also

the asp connection

string.



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.





Set objConn = Server.Createobject("ADODB.Connection")

strConnection = "DSN=Tasc_Data;Database=Ters;"

strConnection = strConnection & "UID=sa;PWD=;"

objConn.open strConnection







Marcus J Pina Jr

Senior Decision Support Analyst

Maricopa County Juvenile Probation Department

(xxx) xxx-xxxx

pager  (xxx) xxx-xxxx

marpia@j...







"If the left side of your brain controls the right side of your body, 

and the right side of your brain controls the left side of your body,

 then left-handed people must be the only ones in their right minds." 



- W.C. Fields

Hi Marcus,



Try to use the following connectionstring:



"PROVIDER=3DMICROSOFT.JET.OLEDB.4.0;DATA SOURCE=3D<complete

path>\Ters.mdb;USER ID=3Dsa;PASSWORD=3D;"



Change the <complete path> part with the complete path to your Ters.mdb

file.



Greetingz,

Hans van Domselaar (hans.van.domselaar@i...)

Web Developer Competence Center

Informaat BV, Baarn, The Netherlands

http://www.informaat.nl







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

From: Marcus Pina - JUVX [mailto:marpia@J...]

Sent: maandag 13 augustus 2001 18:51

To: Access ASP

Subject: [access_asp] Error Trying to query an Access db





All, can someone tell me if their is a way to establish a connection to

a

Access 97 db

with the correct permissions....? below is the error I am receiving and

also

the asp connection

string.



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.





Set objConn =3D Server.Createobject("ADODB.Connection")

strConnection =3D "DSN=3DTasc_Data;Database=3DTers;"

strConnection =3D strConnection & "UID=3Dsa;PWD=3D;"

objConn.open strConnection







Marcus J Pina Jr

Senior Decision Support Analyst

Maricopa County Juvenile Probation Department

(xxx) xxx-xxxx

pager  (xxx) xxx-xxxx

marpia@j...







"If the left side of your brain controls the right side of your body,

and the right side of your brain controls the left side of your body,

 then left-handed people must be the only ones in their right minds."



- W.C. Fields

I think you just have to check whether the database is saved as a read only

file. I have had that problem before and I later realised the database was

set to readonly. Also make sure that the folder where you have the database

has read/write access set.



Chuks Anoshiri

NigExchange Dot Com Ltd

16 Omo Osagie Street

S. W. Ikoyi Lagos Nigeria

Tel: 234-1-2670901, 2673361

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

From: Marcus Pina - JUVX <marpia@J...>

To: Access ASP <access_asp@p...>

Sent: Monday, August 13, 2001 6:51 PM

Subject: [access_asp] Error Trying to query an Access db





> All, can someone tell me if their is a way to establish a connection to a

> Access 97 db

> with the correct permissions....? below is the error I am receiving and

also

> the asp connection

> string.

>

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

>

>

> Set objConn = Server.Createobject("ADODB.Connection")

> strConnection = "DSN=Tasc_Data;Database=Ters;"

> strConnection = strConnection & "UID=sa;PWD=;"

> objConn.open strConnection

>

>

>

> Marcus J Pina Jr

> Senior Decision Support Analyst

> Maricopa County Juvenile Probation Department

> (xxx) xxx-xxxx

> pager  (xxx) xxx-xxxx

> marpia@j...

>

>

>

> "If the left side of your brain controls the right side of your body,

> and the right side of your brain controls the left side of your body,

>  then left-handed people must be the only ones in their right minds."

>

> - W.C. Fields