i'm having trouble connecting to an access database on my own machine. here's my connection string if i try to use ODBC:

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

or if i try to use OLE DB:

<% 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=test"%>

and then my code:

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

and here's my error for ODBC:

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

and my error for OLE DB:

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


i'd like to use OLE DB...but whatever works.
other info: i have MDAC 2.7..****nning XP Pro...using Access 2000...and using MS's component checker i've found that i do have Jet 4.0 installed as well.

i've been working on this bug for awhile...any help would be very appreciated.
thanks.
b

Have you tried using a DSN rather than DSNless connections?

Also try simplifing the path.

e:\data\x.mdb for example

i tried simplifying the path...that didn't work.

how do i use a DSN connection instead? this is on my local machine.
(sorry i'm new to this).

thanks.
b

Here are some links. They will serve you better than me trying to explain it.

http://www.learnasp.com/learn/index.asp

look for

DSN Setup #1 by Rob Martinson

this is a great reference site.

i fine site indeed...

i set up the DSN and tried it instead...only i get the same error...any other ideas?

thanks again for your time.
b

upon viewing aspfaq.com and reading this:

In addition, make sure the anonymous user on your machine (IUSR_machineName) has both read and write access to the folder in which the MDB file(s) reside.

the problem is resolved.

thanks for helping!!

b