Connecting Access Database to Crystal Reports XI

[former_member1118404]

I have a Crystal Report that was working fine up until a couple of days ago. This report is accessing a Microsoft Access Database that is on one of our network shared drives. I used to be able to open the report and refresh the data and it would run pretty quickly. The last couple of days when I try to run the report, it crashes and closes completely out of Crystal. Does anyone know why it is automatically shutting down Crystal? Also, can you explain how I need to go about connecting the database to the report again? I would like to verify that it isn't causing the database issue. We are using Microsoft Access that is part of Microsoft O365. The database is a accdb file not a mdb file. Any suggestions would be greatly appreciated.

[former_member763929]

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with Community Q&A , as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

[DellSC]

Crystal XI is old and has been out of support for at least 12 years. It was never designed to interact with O356 applications. However, there may still be a way to connect to your database.

You need to have the 32-bit Access driver installed. If you're using the 64-bit version of O365, this presents a problem because the driver it includes is 64-bit. Here's a link to some information about some work-around for this: https://stackoverflow.com/questions/12270453/ms-access-db-engine-32-bit-with-office-64-bit

Beyond that, you need to seriously consider upgrading your version of Crystal - there is no guarantee that it will continue to work correctly with future versions of Windows.

-Dell