Skip to Content
author's profile photo Former Member
Former Member

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

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 ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Sep 06, 2010 at 09:31 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 12, 2010 at 12:53 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.