No password is required when using Crystal Reports with a Microsoft Access Report Writer Database or a Blackbaud Report Writer Database (.mdb files)



  1. If prompted for a password in Crystal when adding a new report, the SQL/ODBC option was selected.
     
  2. Creating a report is a 2 step process

    1. Create a data file in Export. Export in MS Access Report Writer Database format
       
    2. Choose Data File, instead of SQL/ODBC to create the report using the
      datafile
Note: If the above two options do not resolve the issue, browse out to where the data file is located and manually delete the Access database lock file.  If this still does not resolve the issue recreate the report.