Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 23, 2008 at 03:36 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 07:50 PM

    Hi Yasmin

    Please let us know the following information to further troubleshoot the issue:

    1) Exact version of crystal Reports. To get this information go to Help > About Crystal Reports.

    2) Do you face the same issue after creating a Data Source Name and using ODBC or OLEDB connection?

    Thanks

    Poonam Thorat

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 07:51 PM

    Hi Yasmin,

    Have you tried creating an ODBC connection to your Access Database and try creating a report of the ODBC connection.

    Hope this helps.

    Regards,

    Vinay

    Add comment
    10|10000 characters needed characters exceeded