Crystal Reports can’t connect to Access 2007

15 pts.
Tags:
Access 2007
Crystal Reports
Crystal Reports XI
Crystal reports Xi to Access 2007
Microsoft Access
We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see the dB's. I think it is the new file extensions with Access 2007. Anyone know how I can connect and see the dB's.
ASKED: January 7, 2009  8:58 PM
UPDATED: January 8, 2009  3:30 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

This download will install a set of components that can be used by non-Microsoft Office applications to read data from and write data to 2007 Office system files such as Microsoft Office Access 2007 (mdb and accdb) files and Microsoft Office Excel 2007 (xls, xlsx, and xlsb) files. Connectivity to text files is also supported.

ODBC and OLEDB drivers are installed for application developers to use in developing their applications with connectivity to Office file formats.

The 2007 Office System Driver are not designed as a general replacement for Jet. If you need a general replacement for Jet you should use SQL Server Express Edition.

Instructions
To install this download:

1. Download the file by clicking the Download button (above) and saving the file to your hard disk.
2. Double-click the AccessDatabaseEngine.exe program file on your hard disk to start the setup program.
3. Follow the instructions on the screen to complete the installation.

To use this download:

1. If you are the user of an application, consult your application documentation for details on how to use the appropriate driver.
2. If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”
* If you are connecting to Microsoft Office Excel data, add “Excel 12.0” to the Extended Properties of the OLEDB connection string.
3. If you are application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
4. If you are application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”

To remove this download:

To remove the download file itself, delete the file AccessDatabaseEngine.exe

1. On the Start menu, point to Settings and then click Control Panel.
2. Double-click Add/Remove Programs.
3. In the list of currently installed programs, select “Microsoft Office Access database engine 2007” and then click Remove or Add/Remove. If a dialog box appears, follow the instructions to remove the program.
4. Click Yes or OK to confirm that you want to remove the program.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following