EJBD
EJBD

Reputation: 23

Crystal Reports 2016 unable to read Access 2016 using OLE DB

I recently upgraded Office to 2016 and I have upgraded Crystal Reports to 2016 as well. As a result, the crystal reports will no longer read the access database.

They were originally connecting just fine using a OLE DB connection type and the Microsoft Office 12 Access Database Engine.

I have reinstalled the Office 2007 connectivity tools and the 64bit Access Database Engine, but they still won't connect.

I've looked around on various forums to find a solution but everything refers to reinstalling the connectivity tools and/or the database engine.

Crystal Reports Error Message

Does anyone know of anything that might resolve this issue?

Upvotes: 1

Views: 834

Answers (1)

Mark Ramsey
Mark Ramsey

Reputation: 11

I've found Crystal Designer can refuse to connect to the datasource even though you provide the correct details, user and password if the database is password protected/encrypted. This only seems to happen in the designer, when opened from an application (say .net) it works fine.

To overcome this in your development environment do this (may differ depending on your version of MS Access):

  1. Open MS Access
  2. Select Open and then browse
  3. Select your database and click the drop down arrow beside the Open button and click open exclusive.
  4. Enter your database password when prompted.
  5. Go File->Info
  6. Click the Decrypt Database and enter your password when prompted.

Close the database, and then try again to connect in Crystal reports. Once you are finished with the designer, you can re-encrypt/password protect your database again.

Upvotes: 0

Related Questions