Skip to Content
avatar image
Former Member

Database Broken/ Compile Errors

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 03, 2017 at 02:34 PM

    CPEAUT32.DLL and craxdrt are legacy dll's an have not been shipped or supported for 10+ years.

    You are mixing just about every version of CR runtime that is likely on your PC.

    Pick one version (13) and stick with it.

    Go to the download page for CR for VS and you'll find samples you can use:

    https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

    Don

    Add comment
    10|10000 characters needed characters exceeded