While attempting to create a 32 bit ODBC System DSN the Microsoft Access Driver (*.mdb) does not show *accdb. Why?
- 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.
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:
Uninstall the 64 bit version of Office 2010 or Access 2010 and install the 32 bit version(s).
Crystal Reports 2011, CR 2010, Access 2010, Office 2010 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To