Which version of Crystal supports MDB files?

Chris Zello
Chris Zello
Sixth Anniversary Kudos 2 Name Dropper Participant
in Blackbaud Raiser's Edge NXT®: General Discussions

According to what I'm seeing at crystalreports.com/datasources, it looks like CR 2020 supports the MDB file format. Can someone verify this?

If it doesn't, could someone verify that CR 2016 supports it?

Tagged:

Comments

  • Joshua Bekerman bCLO, bCRE
    Joshua Bekerman bCLO, bCRE
    Tenth Anniversary Kudos 5 Name Dropper Participant

    I downloaded the trial of 2016 and the mdb files from RE export worked. It also prompted me to update the report/rpt to 2016. I also downloaded 2020 and it did not work with mdb files from RE.

  • Chelsea Powell
    Chelsea Powell
    Eighth Anniversary Kudos 1 Participant Facilitator 1

    Hi! I just wanted to pop in and confirm that crystal reports 2020 does work with MDB files from RE. You do have to connect the data differently though. Here are the steps that worked for me:

    1.On the database expert window, under create new connection, double click the OLE DB (ADO) option

    2. Select Microsoft Office 12.0 Access Database Engine OLE

    3. Hit Next

    4. Under Data Source find the .MDB file you created from RE

    5. On the Office Database Type select Access

    6. Hit Next.

    7. Hit Finish when you get to the advanced information screen. I haven't found a need to change anything at this window yet.

Categories