How do I connect to an Access 2007 Database?

[Former Member]

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,

[Former Member · Accepted solution]

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

[Former Member]

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

[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