Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2002
    Posts
    13

    Unanswered: 80040E4D error - using MS Access/ASP 3.0

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    17
    Have you tried using a DSN rather than DSNless connections?

    Also try simplifing the path.

    e:\data\x.mdb for example
    David Williams
    Senior Jack of All Trades

  3. #3
    Join Date
    Sep 2002
    Posts
    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

  4. #4
    Join Date
    Sep 2002
    Posts
    17
    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.
    David Williams
    Senior Jack of All Trades

  5. #5
    Join Date
    Sep 2002
    Posts
    13
    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

  6. #6
    Join Date
    Sep 2002
    Posts
    13
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •