SAP Knowledge Base Article - Public

1682109 - SAP Crystal Reports 2011 not recognizing Access 2007 database


  • 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)


  • Crystal Reports 2011
  • MS Access 2007


Using the native JET/DAO engine to connect to MS Access 97 and later is no longer supported


Use a 32 bit ODBC datasource to connect to MS Access 97

See Also

1505620  - How to create a 32 bit ODBC data source on a 64 bit Operating System



Access 2007, Access 2010, ODBC, JET/DAO, Crystal Reports 2011 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To


SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports, developer version for Microsoft Visual Studio