Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem recognizing Access 2007 database using Crystal

Has anyone come across the problem of trying to pull up a Access 2007 database, and Crystal not recognizing the extension. I am having a real problem and have to convert the access database to Excel before I run my report as Crystal does not recognize the accdb extension when I select Access.

Former Member
Former Member replied

I don't know if this has been resolved...but...

While using an ODBC connection will work, you can also connect to an Access 2007 database from Crystal Reports XI by selecting OLE DB(ADO), instead of Access/Excel (DAO). Select "Microsoft Office 12.0 Access Database Engine OLE DB Provider" as the Provider.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question