Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2003
    Location
    Pembroke Pines, Florida, USA
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Missing DLL? (Access 2002 SP1)

    Hi all,

    I have an unsecured database sitting out on a network that is accessed by multiple users. This DB has several forms that it runs to allow the users to do searches, add/modify records, preview/print reports. All works well ... except for one user.

    For this one user, he can open up the DB and the initial main form is displayed, but no code will run when he interacts with it. He can click the command buttons but nothing happens. I brought up the Database Objects window and had him interact with tables, queries, brought up specific forms, went into design mode, and viewed the code behind the forms. He can do all this with no problem; but in running the actual form, none of the events that are coded will run (eg. clicking Exit, or Cancel, or Save, or Open Form, does nothing).

    I went back to viewing the code behind the main form and tried to compile it. We then got an error message "Missing .DLL" --- that's it. No indication on what this .DLL is. I am assuming that this missing .DLL is the cause of this problem of Access ignoring the event coding behind the forms.

    We've uninstalled and reinstalled Access 2002 but it did not help.

    Worst case is, this user is my boss. [img]/forums/images/smilies/sad.gif[/img]

    Any ideas out there on what this could possibly be? I initial inclination is a rogue workgroup file out there that has its Admin rights restricted -- is this possible?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Missing DLL? (Access 2002 SP1)

    Although the error message is atypical for it, check for missing references. Open any module, and select Tools/References... Uncheck references starting with MISSING (if any), then click OK and try to compile again. BTW, when you get the "Missing .DLL" error, which line of code is highlighted?

    You can also replace the workgroup file (default System.mdw, probably in Cocuments and Settings<username>Application DataMicrosoftAccess, but the exact location depends on the Windows version) on your boss's PC with a standard one (from another PC).

Posting Permissions

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