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]

Hi

Tested several related workflows today, things seems working well on our machine.

Only thing we can think of now, is to confirm whether newly create report in CR2020 on Access, via ODBC, works.

Any additional suggestions to narrow down this issue, please?