i'm having trouble connecting to an access database on my own 
machine...it's the first time i've tried to do this. here's my code:

<% strConn = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=E:\Documents 
and Settings\Bob J. Roberts\My Documents\Work\SafetyKids\safetykids.mdb" %
>

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

and here's my error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open 
registry key 'Temporary (volatile) Jet DSN for process 0xdec Thread 0xee8 
DBC 0x14d0064 Jet'.
/work/asp/SafetyKids/admin/editor/editor.asp, line 4

i don't understand why anything would be wrong with my registry.

any ideas??

thanks.
b

The joys of ODBC.

Use OLEDB instead:
www.adopenstatic.com/faq/whyOLEDB.asp

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Bryan Nelson" <bjnst6@h...>
Subject: [access_asp] trouble connecting to access db


: i'm having trouble connecting to an access database on my own
: machine...it's the first time i've tried to do this. here's my code:
:
: <% strConn = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=E:\Documents
: and Settings\Bob J. Roberts\My Documents\Work\SafetyKids\safetykids.mdb" %
: >
:
: <% Set conPubs = Server.CreateObject("ADODB.Connection")
: conPubs.ConnectionString = StrConn
:    conPubs.Open
:   'cool stuff here
: conPubs.Close
:  %>
:
: and here's my error:
:
: Error Type:
: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
: [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
: registry key 'Temporary (volatile) Jet DSN for process 0xdec Thread 0xee8
: DBC 0x14d0064 Jet'.
: /work/asp/SafetyKids/admin/editor/editor.asp, line 4
:
: i don't understand why anything would be wrong with my registry.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

excellent resource...and i've decided to use OLE DB instead...only now i 
get this error with this 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=mypassword"%>

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

Error Type:
Microsoft JET Database Engine (0x80040E4D)
Cannot start your application. The workgroup information file is missing 
or opened exclusively by another user.
/work/asp/SafetyKids/admin/editor/editor.asp, line 4


any ideas now??
thanks.
b