BSA ALUMNI CONTACT DATABASE 
 

Troubleshooting

The Alumni database system has been developed with Microsoft Access 2007.  It also uses components from Microsoft Windows, Microsoft Outlook, Microsoft Word, and Microsoft Excel. 

The way Access works is to use "modules" from the components it references.  To be able to use these modules however, Access needs to know where they are and which modules are to be used.  This information is configured for the Access runtime module. 

There is no way to "automatically" configure these modules and the configuration on any given computer is somewhat random.  Because of this, it may be necessary to configure your system to provide the references to the needed modules.  You will only have to do this one time -- Access will "remember" the configuration in the future!

The "symptom" of not having the necessary configuration is that the application may not "behave" the way you would expect it to.  An example of this is pressing the "Browse" button when trying to import a file.  The expected action would be to bring up an "open" dialog where you can locate the file and "open" it.  If the "open" dialog does not appear or the file doesn't open, the configuration probably is incorrect.

The configuration process consists of two parts:  1) determining which module(s) are missing and 2) configuring the modules for Access.  The steps for these processes are shown below.

1.    Determine which module(s) are not configured.

Update the database to at least the 2.3 version and start it.

When you have the alumni system running with the main form displayed, please follow the steps here:
 1.      When Alumni Contact form is displayed, press Alt-F11 to open Visual Basic Editor
 2.      When Visual Basic Editor is displayed, type Ctrl-G to go to the Immediate window
 3.      In the Immediate window, type "?ReferenceInfo" (without the quote marks) & press Enter
         A list of “modules” will be displayed.  It should look like:
             ?referenceinfo
             Reference:  VBA
                Location:  C: \Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
             Reference:  Access
                Location:  C: \Program Files\Microsoft Office\Office12\MSACC.OLB
             Reference:  stdole
                Location:  C: \Windows\system32\stdole2.tlb
             Reference:  DAO
                Location:  C: \PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEDAO.DLL
             Reference:  Office
                Location:  C: \Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLL
             Reference:  Outlook
                Location:  C: \Program Files\Microsoft Office\Office12\MSOUTL.OLB
             Reference:  MSComctlLib
                Location:  C: \Windows\system32\MSCOMCTL.OCX

If the 7 references (VBA, Access, stdole, DAO, Office, Outlook, MSComctlLib) are shown with locations, the problem lies in another area.  Contact the author at bsaAlumni_2010@att.net.

2.    Configure the missing module(s).

  1. The modules have "names", these are:

    Reference  Common Name Library Reference Name

       VBA

    		 Visual  Basic For Applications  Visual Basic for Applications 

       Access

    		 Microsoft Access 12.0 Object Library  Microsoft Access 12.0 Object Library 

       stdole

    		 OLE Automation  OLE Automation 

       DAO

    		 Microsoft Access 12.0 Object Library  Microsoft Office 12.0 Access Database Engine Object Library 

       Office

    		 Microsoft Office 12.0 Object Library  Microsoft Office 12.0 Object Library 

       Outlook

    		 Microsoft Outlook 12.0 Object Library   Microsoft Outlook 12.0 Object Library 

       MSComctlLib

    		 Microsoft Windows Common Controls 6.0 (SP6)
         		 Microsoft Windows Common Controls 6.0 (SP6)
     

  2. In the Visual Basic Editor, click on "Tools" in the command bar at the top.  A dropdown list will appear, click on "References..."
    A dialog box will appear, if Access is properly configured, the dialog box will look like:

    3.  

  3. From the list in Step 1 above, determine which reference is not checked in the dialog box above.  If, for example, the "Microsoft Office 12.0 Object Library" does not appear in the dialog box and "Reference: Office" did not appear in Step 1, you will need to add it.  This may need to be repeated for other missing modules until you can repeat Step 1 and all 7 references are shown.
    NOTE:  if you do not see the reference in the list, click the Browse... button and search for the module or type in the file path shown in Step 1 above.

  4. To configure a module, use the vertical scroll bar and scroll to the missing module, they are in alphabetic order.  When you find the reference, click the checkbox to the left of the name.  Continue doing this until all missing modules are checked.  Click OK to configure the module references.  You may get a warning box that "this action will reset your project ...", click OK to ignore this message.

  5. Continue configuring the modules until you can repeat Step 1 and all 7 modules appear. 

  6. When all 7 module references are present, exit the Visual Basic Editor by pressing Alt-F11.  Exit the Alumni database and restart it.  When it has restarted, try to recreate the "problem" you originally had to determine if this corrected it.

  7. If the problem is not corrected or if all references were present here, contact the author with as much detailed information about the problem as possible. 

 

Last updated Friday, March 05, 2010 10:49 PM