Results 1 to 3 of 3

Thread: Crystal Reports and Access 2000

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jan 1999
    Location
    Halifax, NS Canada
    Posts
    30

    Wink

    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?


  2. #2

    Thumbs up

    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.
    Madhusudana Gorthi [email protected]
    Senior Software Engineer
    www.stgil.com

  3. #3
    Hyperactive Member
    Join Date
    Feb 2000
    Location
    Edgerton, WI
    Posts
    381
    gorthims,

    Could you explain how to do this? I've never connected through an ODBC driver before.

    Thanks,
    Michael

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width