80040E4D error - using MS Access/ASP 3.0 [Archive]

View Full Version : 80040E4D error - using MS Access/ASP 3.0

bjnst6

09-30-02, 16:37

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

dwilliams

09-30-02, 17:47

Have you tried using a DSN rather than DSNless connections?

Also try simplifing the path.

e:\data\x.mdb for example

bjnst6

09-30-02, 18:13

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

dwilliams

09-30-02, 18:23

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.

bjnst6

09-30-02, 18:47

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

bjnst6

09-30-02, 18:56

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