CR 2025 Mapping Fields

[johnathan_perrybe4cb4]

Crystal Reports 2025
Set Datasource Location

Changing DB connection of my Access DB from DAO to OLE DB

Map Fields window appears - "Match type" is unticked, but I still don't see any database fields that I can map.
I'm not sure why. It is the same MDB file. SAP Crystal Reports 

[DonWilliams · Accepted solution]

Crystal Reports 2025 is 64 bit application so you need a 64 bit Access Database client.

You can get it here:

https://support.microsoft.com/en-us/access/download-and-install-microsoft-365-access-runtime

So when selecting the OLE dB provider you should select this one, see attached oledb.jpg:

Now you should see the connection.

Possible Problem is connecting to the original source may be 32 bit and CR may have problems setting to a 64 bit source but see it that works.

[johnathan_perrybe4cb4 · Accepted solution]

I have tried both the 12.0 and 16.0 Access Database Engine's. I have Full Version of Access 365 Installed.

[DonWilliams · Accepted solution]

Quick test, do you see the fields in a new report using both OLE DB and ODBC connections to the new data source?

It's failing because CR can't match the data types from CSV to OLE DB, it's DB client issue. CSV are likely all strings where as the DB connection are specific field types other than strings.

Try creating a 64 bit ODBC connection to see it that help, ODBC is more forgiving with field types.

If it does you may need to do the conversion in multiple steps to get to OLE DB.