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.
Susan O'Brien 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.