Crystal 9.0 Not Connecting to Access 2007

[shelby55]

Hello

I recently upgraded my Office Suite to 2007 but when trying to create a connection to the Access 2007 database, it doesn't show up as a database to be able to select.

I'm assuming it is the new extensions but how do I fix this? Thanks.

 

[hilfy]

You probably can't. Crystal 9 is old and I doubt it will ever connect to the newer versions of Access. Does Access have the ability to save into the older format of the database? That may be the only way to get this short of upgrading Crystal.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[shelby55]

Hi

Actually, based on another response Ido gave to someone who couldn't link to a more recent version of Excel, I was able to fix this (I think).

What they suggest is creating a DSN to the database and then make an ODBC connection to the DSN in the report. I still have to play with this because even though I can see the test table and copy fields into the details section when I try to run it I get the error message "the database table "tblstuff" cannot be found. Proceed to remove this table from the report?". I said no and the report ran showing the items from tblstuff so maybe the table error dialog box is incorrect.

This was just a test table with 3 items in it so I may still have issues but will continue to test. Thanks for your response.