Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Error in loading DLL

Discussion in 'Information Technology' started by Nuno Oliveira, Nov 10, 2005.

Tags:
  1. Nuno Oliveira

    Nuno Oliveira
    Expand Collapse
    Guest

    Hi,

    I'm using Access 2003.
    When I try to open a form in my database I get this message " The expression
    On Open you entered as the event property setting produced the following
    error: Error in loading DLL".
    Database is stored in the office internal network and other colleagues still
    open the database without any problems.

    I've performed all Office and Windows updates and the problem persists.

    Can anyone help me?

    Thks
    Nuno
     
  2. Loading...


  3. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "Nuno Oliveira" <Nuno Oliveira@discussions.microsoft.com> wrote:

    >Hi,
    >
    >I'm using Access 2003.
    >When I try to open a form in my database I get this message " The expression
    >On Open you entered as the event property setting produced the following
    >error: Error in loading DLL".


    I suspect you have extra references in the MDB which exist on your
    colleagues system but don't exist on your system.

    Do you have any references besides the basic three? Are you sure you
    need them? Write down the path and name of the extra ones, delete
    from the references list and Compile and Save All. Keep any
    necessary references and ensure they are distributed to the target
    system.

    For a very detailed page on reference problems see
    http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

    Ctrl+G will take you into the Debug/Immediate window. Then click on
    Tools on the menu bar and References.

    The Access 2003 default references when the MDB is in A2000 format are
    Visual Basic for Applications
    Microsoft Access 11.0 Object Library
    OLE Automation
    Microsoft DAO 3.6 Object Library
    Microsoft ActiveX Data Objects 2.1 Library

    The Access 2003 default references when the MDB is in A2002/A2003
    format are
    Visual Basic for Applications
    Microsoft Access 11.0 Object Library
    OLE Automation
    Microsoft DAO 3.6 Object Library
    Microsoft ActiveX Data Objects 2.5 Library

    >Database is stored in the office internal network and other colleagues still
    >open the database without any problems.


    However this concerns me. Are you folks all sharing the same front
    end MDB on the server? If so you run an increased risk of corruptions
    as well as weird problems. I'd strongly suggest giving each person
    their own copy of the front end.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page