hello there...

i'm using ASP 3.0 and trying to connect to an access db...i'm using OLE 
DB for my connection...here's the code:

<% strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:\Documents 
and Settings\Bryan J. Nelson\My 
Documents\Work\SafetyKids\safetykidsdb.mdb;"  & _
             "User Id=admin;Password=password"%>

<% Set conPubs = Server.CreateObject("ADODB.Connection")
	 conPubs.ConnectionString = StrConn
   conPubs.Open 
	  'cool stuff here 
	 conPubs.Close
 %>

i have MDAC 2.70.7 installed and i have Jet 4.0 installed as well...and 
here's the error i'm getting...just trying to connect to the db on my own 
machine:

Microsoft JET Database Engine (0x80040E4D)
Cannot start your application. The workgroup information file is missing 
or opened exclusively by another user.


any insight would be much appreciated!!
thanks,
b

Hi!

You can, AFAIK, skip the username and password in the connection string if you do not use regulate security through a .mdw
file(workgroup file).

Hakan

and ---------- Original Message ----------------------------------
From: "b" <bjnst6@h...>
Reply-To: "ASP Databases" <asp_databases@p...>
Date:  Mon, 30 Sep 2002 20:00:31

>hello there...
>
>i'm using ASP 3.0 and trying to connect to an access db...i'm using OLE 
>DB for my connection...here's the code:
>
><% strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:\Documents 
>and Settings\Bryan J. Nelson\My 
>Documents\Work\SafetyKids\safetykidsdb.mdb;"  & _
>             "User Id=admin;Password=password"%>
>
><% Set conPubs = Server.CreateObject("ADODB.Connection")
>	 conPubs.ConnectionString = StrConn
>   conPubs.Open 
>	  'cool stuff here 
>	 conPubs.Close
> %>
>
>i have MDAC 2.70.7 installed and i have Jet 4.0 installed as well...and 
>here's the error i'm getting...just trying to connect to the db on my own 
>machine:
>
>Microsoft JET Database Engine (0x80040E4D)
>Cannot start your application. The workgroup information file is missing 
>or opened exclusively by another user.
>
>
>any insight would be much appreciated!!
>thanks,
>b
>