none
Database Broken / Compile Errors RRS feed

  • Question

  • Version: Access 2010
    References for Database:
    Visual Basic for Applications
    Microsoft Access 14.0 Object Library
    OLE Automation
    Microsoft Office 14.0 Access database engine Object Library
    MISSING: Crystal Report Engine 8 Object Library
    MISSING: Crystal Reports 8.5 ActiveX Designer Run time library

    Issue: 
    When opening up the Access file, it pulls up 3 different errors:
    1) Your database or project contains a missing or broken reference to the file 'CPEAUT32.DLL' version 8.0
    2) Your database or project contains a missing or broken reference to the file 'craxdrt.dll' version 8.5
    3) An error occurred while loading 'Report'. Do you want to continue loading the project.

    I am aware that the first two issues are due to the missing references. I have tried to reset it by unchecking them then saving, but when I try it comes up with the error that it couldn't save. When I have unchecked them, then gone back in to check them, they are missing. We have a lot of crystal reporting options, I'm just not sure which ones would be the updated versions of the other two, or really what to do either way. Here is the list of Crystal Reporting references I can choose from.

    Crystal Client Document Library 11.0
    Crystal Client document Library 13.0
    Crystal Data Object Library 2.7
    Crystal Enterprise AFDPlugin PlugIn 11.0

    Crystal Enterprise AppFoundation PlugIn 11.0
    Crystal Enterprise APS Administration Library 11.0
    Crystal Enterprise Calendar PlugIn 11.0
    Crystal Enterprise CMC PlugIn 11.0
    Crystal Enterprise Connection PlugIn 11.0
    Crystal Enterprise Designer PlugIn 11.0
    Crystal Enterprise Discussion PlugIn 11.0
    Crystal Enterprise Event PlugIn 11.0
    Crystal Enterprise Excel PlugIn 11.0
    Crystal Enterprise Favorites Folder PlugIn 11.0
    Crystal Enterprise Framework 11.0
    Crystal EnterpriseHyperlink PlugIn 11.0
    Crystal Enterprise Inbox PlugIn 11.0
    Crystal Enterprise InfoStore Library 11.0
    Crystal Enterprise InfoView PlugIn 11.0
    Crystal Enterprise LicenseKey PlugIn 11.0
    Crystal Enterprise MyInfoViewPlugIn 11.0
    Crystal Enterprise Object Package PlugIn 11.0
    Crystal Enterprise Overload PlugIn Library 11.0
    Crystal Enterprise Pdf PlugIn 11.0
    Crystal Enterprise Plugin Manager Library 11.0
    Crystal Enterprise Powerpoint PlugIn 11.0
    Crystal Enterprise Program PlugIn 11.0
    Crystal Enterprise Report Plugin Library 11.0
    Crystal Enterprise RTF PlugIn 11.0
    Crystal Enterprise secEnterprise PlugIn 11.0
    Crystal Enterprise secLDAPConfig PlugIn 11.0
    Crystal Enterprise secWinAD Config PlugIn 11.0
    Crystal Enterprise secWindowsNTConfig PlugIn 11.0
    Crystal Enterprise Server Group PlgIn Library 11.0
    Crystal Enterprise Server PlugIn Library 11.0
    Crystal Enterprise Shortcut Plugin Library 11.0
    Crystal Enterprise Txt PlugIn 11.0
    Crystal Enterprise User PlugIn 11.0
    Crystal Enterprise UserGroup PlugIn 11.0
    Crystal Enterprise WebIntelligence PlugIn 11.0
    Crystal Enterprise Word PlugIn 11.0
    Crystal Query Engine
    Crystal QueryEngine Library 13
    Crystal Reports Common Object Model Library 11.0
    Crystal Reports Controllers Library 11.0
    Crystal Reports Data Definition Model Library 11.0
    Crystal Reports HTML Report Renderer 11.0
    Crystal Reports Object Factory Library 11.0
    Crystal Reports Page Object Model Type Library 11.0
    Crystal Reports Print Control Library 11.0
    Crystal Reports Prompts EMF Library
    Crystal ReportsReports Definition Model Library 11.0
    Crystal Reports Report Source Bridge Library 11.0
    Crystal Reports SAX Serialize Type Library 11.0
    Crystal Reports Timplate engine Type library 11.0
    Crystal Reports Web Reporting Type Library 11.0
    Crystal Reports Common Object Model Library 13.0
    Crystal Reports Controllers Library 13.0
    Crystal Reports Data Definition Model Library 13.0
    Crystal Reports HTML Report Renderer 13.0
    Crystal Reports Object Factory Library 13.0
    Crystal Reports Page Object Model Type Library 14.0
    Crystal Reports Print Control Library 13.0
    Crystal ReportsReports Definition Model Library 13.0
    Crystal Reports SAX Serialize Type Library 13.0

    There are other errors that come up when opening up different forms in the report, such as: 
    ODBC --connection to 'name' failed
    Compile Errors in query expression:
    Mid([Order_Lines.RECORD_NO]1,3)
    Year([True Due Date])
    Trim([non_INVENTORY_REC]![DESCRIPTION])
    Trim([DESCRIPTION])
    IIf(IsNull([ON_Hand]),[qty_ordered],IIf([ON_Hand]*-1<0,"0",[ON_Hand]*-1)
    Format([DATE_INVOICE],'mm/yy')

    I think some of them have to do with the missing references and that the ODBC connection failed, but to be honest I don't know much about this stuff. 

    Any help is appreciated. Thank you in advance

    Monday, October 2, 2017 3:01 PM

All replies

  • Unfortunately we cannot provide you with Crystal Reports assistance, but it sounds like the missing references are breaking your database app, which is expected. I wouldn't even attempt to resolve any applications issues until you resolve the Crystal Reports references issue.

    I suggest you contact SAP since they are the vendor for Crystal Reports.


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Monday, October 2, 2017 4:02 PM
  • Before you un-check any Crystal Reports libraries, make a backup of the database. That way if you select the wrong replacement you won't lose those two missing references.

    As Paul said, SAP would be the one to ask. Usually, it's just the version number that changes, but I don't see anything in your list like that.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Monday, October 2, 2017 9:29 PM