Crystall Reports 2008 SP2 Any Fixes to allow Reading Access 2007 files ?

[Former Member]

Using Crystal Reports 2008 SP2. Just applied SP2 . Is there a solution for the issues with NOT being able to Read MS Access 2007 database files ? With SP2 I still have to save the MS Access DB in a 2003 Version format in order to access with Crystal Reports 2008 ?

[Former Member]

I may be setting the cart before the horse by asking, but what issues were you having?

It sounds like you were totally unable to connect.

I am using XI and through OLE DB (ADO), I have connectivity.

I installed a version release of my database which took the database from Access 2000 to Access 2007. My connection ended. I worked with people here on the forum trying to connect with nothing working. Once I received a database password from my database vendor, the connectivity issue was gone. The password was normally not given out, so it was a table-level password.

However, I have found two issues. If I pull data it all shows up correctly. If I use Select Expert to look for true only in a boolean field, the report comes back blank after refreshing. Without refreshing, I see only the True boolean fields, as I should. A similar problem is found using a date or range of dates in Select Expert. Blank with refresh, or without a refresh, it shows me the correct data.

Have you asked your technical support at the vendor of your database?

Thank you,

Greg Harper

[former_member11696]

Hello,

No issues at all other than we don't support connecting to them using the native JET/DAO engine. Use ODBC or OLE DB and it will all work for you. Microsoft did not have a 64 bit version so they only supported it using ODBC or OLE DB.

CR 2010 ( next version ) will support it natively.

Thank you

Don