Crystal Reports 2020 not connecting to Access Database using ODBC 64 Bit Access driver.

[guy_c_biscardi18]

I’m unable to connect to my database.

I followed the steps in the Crystal Reports 2020 Access to 64 Bit Version guide as follows:

I downloaded the 64 Bit version of the Microsoft Access Database Engine 2010 Redistributable.

Then, I created an ODBC entry for the Database connection:

I called the System DSN “Access 64 accdb Database”:

I opened Crystal Reports 2020 and selected my existing report. I selected the Database Menu chose Set Database location. I created a new connection by Selecting the ODBC (RDO) option. I selected the ODBC connection I created and assigned it the Current Data Source:

When I tried to Verify the Database, I got the following message:

I’m hoping someone can help me fix this problem.

Guy Biscardi

[vinay_hegde]

Also use 64-bit version of the Microsoft Access database engine 2016 Redistributable.