Symptom
- Connecting to an Access *.accdb file from Access 2007
- Using native connection to Access (Access/Excel (DAO))
- The *.accdb files are not visible in the Crystal Reports Designer (under the Database menu->Set datasource location)
Environment
- Crystal Reports 2011
- MS Access 2007
Cause
Using the native JET/DAO engine to connect to MS Access 97 and later is no longer supported
Resolution
Use a 32 bit ODBC datasource to connect to MS Access 97
See Also
Keywords
Access 2007, Access 2010, ODBC, JET/DAO, Crystal Reports 2011 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports, developer version for Microsoft Visual Studio