Reputation: 23
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.
Does anyone know of anything that might resolve this issue?
Upvotes: 1
Views: 834
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):
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