SAP Knowledge Base Article - Public

1684166 - How to: Connect Crystal Reports 2011 to Access 2010 through 32 bit ODBC with Microsoft Office 2010 64 bit

Symptom

While attempting to create a 32 bit ODBC System DSN the Microsoft Access Driver (*.mdb) does not show *accdb. Why?

Environment

  • Crystal Reports 2011
  • Crystal Reports for Visual Studio 2010
  • Windows XP 64 bit
  • Windows 7 64 bit
  • Microsoft Office 2010 64 bit
  • Microsoft Access 2010 64 bit

Reproducing the Issue

Office 2010 64 bit or Access 2010 64 bit is installed.

In order to connect Crystal Reports 2011 ( 32 bit application ) to Access 2010 ACCDB file type an ODBC Connection is required.

  • Open the ODBC Administrator in ODBC ( 32 bit ) admin located in \windows\syswow64 folder.
    • Or type ODBC in the Start Search line and both 32 and 64 bit ODBC Administrators will be listed. Select the 32 ODBC Admin link.
  • Create a new System DSN and scroll to "Microsoft Access Driver (*.mdb). Note the *.accdb file is not available.

ALSO NOTE: Open the 64 bit ODBC Administrator ( \windows\system32 ) and do the same as above and the ( *.mdb, *.accdb ) is available.

Cause

Crystal Reports 2011 is 32 bit application and therefore requires ALL 32 bit dependencies.

Microsoft does not install the 32 bit DataAccess Components with Office 2010 64 bit.

See these Microsoft Articles for the reason:

An Article from Microsoft on their Database and Driver Road Map:

Resolution

Uninstall the 64 bit version of Office 2010 or Access 2010 and install the 32 bit version(s).

Keywords

Crystal Reports 2011, CR 2010, Access 2010, Office 2010 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports, developer version for Microsoft Visual Studio