Resolve Missing or Broken Reference

Catalyst Manufacturing contains references to objects and libraries that Catalyst needs to function properly. When the user opens the Catalyst database, the program checks for missing references and prompts the user if any files are missing. In most cases, re-installing Catalyst or Microsoft Access® will correct the problem. However, a missing reference error may also indicate that more than one version of Access is installed on the machine, the wrong version of Access is installed (e.g. 64-bit instead of 32-bit) or a control or driver did not properly register or became unregistered for some reason.  A reinstallation of the software only addresses broken or missing references when a control needs to be installed and re-registered.  Any other root causes would need to be addressed prior to re-installing the software.

In cases where the Catalyst front-end database has been modified and is copied to both 32-bit and 64-bit client machines, the Catalyst Agent reference must be updated for each desktop environment (e.g. Program Files\Catalyst vs Program Files (x86)\Catalyst paths).  In versions of the software that are distributed with an accdb extension (Full and Pharma Editions), missing or broken references can be checked using the Visual Basic® Editor as described in the steps below. These steps do not apply to the Basic Edition since it is distributed as an execute-only (accde) database and does not have a separate Catalyst Agent reference file.

  1. In the Full Edition, open the Catalyst front-end database by holding down the shift key at the same time you press OK on the login dialog box.

  2. Open the VB Editor by either selecting View > Code from the Microsoft Access® menu or pressing Alt-F11.

  3. From the VB Editor, select Tools > References from the menu bar. Missing references will be identified with a “MISSING” tag beside the reference checkbox.



  4. If the Catalyst Agent reference is missing, it probably means that it is located in a different path than specified in the reference. To correct, uncheck the checkbox for the Catalyst Agent, click OK to close the Reference dialog, reopen by selecting Tools > References and browse and select the Catalyst Agent.accde file from the correct path.
  5. Close the References screen. Select Debug > Compile Catalyst Manufacturing from the VB Editor menu. After the project finishes compiling, close the VB Editor.

  6. From the Microsoft Access ribbon menu, select Database Tools > Compact and Repair Database. Close Catalyst when the process completes.

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk