compile error in loading dll

Discussion in 'Microsoft Access' started by Guest, Sep 30, 2005.

  1. Guest

    Guest Guest

    I am using Access 2003.

    When I load my database, when the switchboard tries to load I get an error
    "Compile error in loading dll". The word connection is highlighted in the
    following statement:
    Set con = Application.CurrentProject.Connection

    I have seen others with this problem but no solutions.

    Can anyone help?

    Thanks in advance.

    Mark
     
    Guest, Sep 30, 2005
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    Hi Mark,

    It sounds like your MDAC installation is hosed. Try using the MDAC Component
    Checker, which you can download from here:

    http://support.microsoft.com/?id=307255


    Tom

    http://www.access.qbuilt.com/html/expert_contributors.html
    __________________________________________

    :

    I am using Access 2003.

    When I load my database, when the switchboard tries to load I get an error
    "Compile error in loading dll". The word connection is highlighted in the
    following statement:
    Set con = Application.CurrentProject.Connection

    I have seen others with this problem but no solutions.

    Can anyone help?

    Thanks in advance.

    Mark
     
    Guest, Sep 30, 2005
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    PS.
    I assume you have already checked for any MISSING references, and/or
    refreshed your references list, since you stated "I have seen others with
    this problem but no solutions."

    Solving Problems with Library References (Allen Browne)
    http://allenbrowne.com/ser-38.html

    Access Reference Problems (Doug Steele)
    http://www.accessmvp.com/djsteele/AccessReferenceErrors.html


    Tom

    http://www.access.qbuilt.com/html/expert_contributors.html
    __________________________________________

    :

    Hi Mark,

    It sounds like your MDAC installation is hosed. Try using the MDAC Component
    Checker, which you can download from here:

    http://support.microsoft.com/?id=307255


    Tom

    http://www.access.qbuilt.com/html/expert_contributors.html
    __________________________________________

    :

    I am using Access 2003.

    When I load my database, when the switchboard tries to load I get an error
    "Compile error in loading dll". The word connection is highlighted in the
    following statement:
    Set con = Application.CurrentProject.Connection

    I have seen others with this problem but no solutions.

    Can anyone help?

    Thanks in advance.

    Mark
     
    Guest, Sep 30, 2005
    #3
  4. Guest

    Guest Guest

    Hi Robert,

    You answered to "Mark", however, I am unable to find the message when using
    the MS web portal, the Comcast News Server (using Outlook Express
    newsreader), or via a Google search. It is helpful to include the text of the
    message that you are replying to, so that in case others do not see the
    original message, at least they can read it if you include it (as I have
    included your post, below).

    I recommend re-registering the following three files. Note that the path to
    each file may be different on your PC. To do this, click on Start > Run. Then
    copy each of the statements shown below, one-at-a-time, and click on Enter:

    Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao350.dll
    Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao360.dll
    Regsvr32.exe C:\progra~1\common~1\system\ado\Msado15.dll

    References:
    http://support.microsoft.com/?id=167591
    http://support.microsoft.com/?id=833220

    Special Note: KB 833220, as currently written, contains an error in the long
    path examples for registering DAO360.dll and MSADO15.dll. You will get the
    following error if you use the commands shown in Method 1, section 2 of this
    KB article:

    LoadLibrary("C:\Program") failed - The specified module could not be found.

    To correct this error, you need to enclose paths that include spaces with
    double quotes. For example, use this instead to re-register the DAO360.dll
    file:

    Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

    If you still cannot get the switchboard and/or wizards to function properly,
    then download the MDAC Component Checker utility and run it on your PC:

    http://support.microsoft.com/?id=307255


    Good Luck,
    Tom

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________
     
    Guest, Jan 19, 2006
    #4
  5. Guest

    Guest Guest

    Hi Robert,
    Nothing more than you've already guessed....that the uninstall program of
    some application caused these problems.

    I'm glad to hear that you like the information that you've discovered at
    QBuilt.com. There's been a lot of effort put into that web site by several
    people!


    Tom

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    :

    Tom,
    Thanks for the reply. and you suggestion was on the money! Prior to
    finding your suggestion and many hours of searching internet last night
    and this morning I came across a tool at:
    http://www.macropool.de/download/CSRepair.exe

    This tool re-registers Jet and Mdac. I don't know anything about this
    program or company... only that it solved the problem for me after I
    spent a day finding many posts with the same problem but no solution.
    Now watch this program install a trojan that wipes my hard drive or
    steals my identity. All that I can say is that it worked great at what
    it said it would do.

    My biggest concern is what caused the problem in the first place. After
    i posted here I remember that I also uninstalled FileMaker Developer 7
    as well as 3 VB applications and one FoxPro. I had re-installed
    everything except FMP, hoping that would re-install/re-register any
    files that the un-installed removed. The reason I didn't re-install FMP
    is because I had forgotten I had un-installed it.

    Any thoughts on cause?
    Thanks! robert

    PS: the one upside to all this is that i fould your wonderfully helpfum
    website/forums.
     
    Guest, Jan 19, 2006
    #5
  6. Guest

    Guest Guest

    Guest, Jan 20, 2006
    #6
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.