Which version of Crystal supports MDB files?

Options
Chris Zello 2
Chris Zello 2 ✭
Fifth Anniversary Facilitator 1 Name Dropper Photogenic
in Blackbaud Raiser's Edge NXT®: General Discussion

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 Facilitator 3 Name Dropper Photogenic

    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 Photogenic First Reply

    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