-
I am trying to create a crystal report using
Crystal Reports 4.6 and an Access 2000 database.
When I try to add the database to my report, I am prompted for a password. There is no password on the database. It will accept an Access 97 database with no problem. If I click 'Cancel' on the prompt input box, I get a message saying: "Error Recognizing File. The file is not a known database type. Please choose again."
Is Access 2000 not compatible with Crystal Reports?
Does anyone have any idea how to overcome this problem?
-
Crystal reports Engine does not contain a native driver for Access 2000. You have to connect through ODBC drivers only. If you have Access 2000 in your machine then you can create the DSN for that Database. After that you can connect to it using ODBC.
-
gorthims,
Could you explain how to do this? I've never connected through an ODBC driver before.
Thanks,
Michael