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

connecting crystal reports 2008 to access database with microsoft.ACE.OLEDB.12.0

We upgrade our microsoft office to office365 64bit and now we cannot connect the crystal reports to the access database .accdb. When we look at the defined connecton properties in crystal reports under the set datasource loacation we have the following info.

Database Type: OLE DB (ADO)

Provider: Microsoft.ACE.OLEDB.12.0

Data Source: \\computername\dir1\dir2\access database name.accdb

User ID: Admin

Jet System Database:

Office Database Type: Access

Use DSN Default Properties: False

Locale Identifier:1033

OLE DB Service: -6

When we try to update the report a window opens with provider options listed but the Microsoft.ACE.OLEDB.12.0 is not listed. We have tried to use others entries in this list but we cannot make it work. Is there an update to office 365 64bit that will let us use and OLEDB connection?

Any help is greatly appreciated.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jan 03, 2014 at 04:56 PM

    Remember that Crystal Reports ia a 32 bit application and thus will not be able to connect to 64 bit datasources. For more information use the search string 'accdb access crystal' in the search box at the top right corner of this web page. Then filter for "Support Notes" (left side of page).

    - Ludek

    Senior Support Engineer AGS Product Support, Global Support Center Canada

    Follow us on Twitter

    Add a comment
    10|10000 characters needed characters exceeded

    • Try using 32 bit ODBC Administrator, located in \windows\syswow64 folder, and see if that works.

      As Ludek said, CR Designer is a 32 bit application so it requires a 32 bit Client/datasource.

      Check with Microsoft to see if they have a 32 bit version of that OLE DB Provider, if so then it should work.

      Don

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.