Skip to Content
author's profile photo Former Member
Former Member

How do I connect to an Access 2007 Database?

Hi all, I see Access and OLEDB as options in Crystal Reports 2008, but none of them connect to my Access 2007 Database. Is there an update or something I have to install for this? Nothing I have tried has been able to work...

Thanks Again,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2008 at 04:02 PM

    Hi Matt,

    Try using Datadirect Driver 5.3 version for crystal reports 2008 and create an odbc connection for your access 2007 database.

    Regards,

    Vinay

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2010 at 05:27 PM

    There's a note in the Platform Support documents for Crystal Reports 2008 explaining how to connect to Access 2007:

    u2013 DAO technology cannot be used to access the Microsoft Office 2007 file formats: Microsoft Access 2007 .accdb, Microsoft Excel 2007 .xlsx (XML) and .xlsb (Binary). These file formats are supported via the Microsoft 2007 Office System drivers for ODBC and OLEDB

    You can download the Office 2007 OLEDB and ODBC drivers for free from Microsoft by searching the Microsoft Office Web site for the download named, "Microsoft 2007 Office System drivers for ODBC and OLEDB".

    You can then use either OLEDB or ODBC and choose the driver named "Microsoft Office 12.0 Access Database Engine OLE DB Provider". This engine is used for Access 2007 databases as well as Excel 2007 (.xlsx and .xlsb) files. Crystal Reports 2008 has special knowledge of this OLE DB driver and provides specific prompting for the use of Access or Excel data sources.

    If you choose to use ODBC, be aware that the Control Panel on 64-bit versions of Windows shows the 64-bit ODBC Manager. Crystal Reports 2008's Start menu folder includes the necessary link to the 32-bit ODBC Manager for use with 32-bit applications and connectivity (which Office 2007 and Crystal Reports 2008 are).

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I can follow all of the steps except one not mentioned in your answer:

      After I complete the "Set Datasource Location" window, the "Advanced Information" window opens. It has a "Name" and a "Value" column that I simply do not know what to do with. The window I get has two listings -- "Locale identifier" with a value of "1033" and "OLE DB Services" with a value of "-6." I am clueless.

      rmssql

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.