1876546 - Crystal Reports based on MS Access file asks for login credentials repetitively

SAP Knowledge Base Article - Public

1876546 - Crystal Reports based on MS Access file asks for login credentials repetitively

Symptom

A Crystal Report based on unique ODBC connection with Access file which is secured with User Name and Password, while refreshing the report asks for login credentials for each record in the Access File.

Environment

  • SAP Crystal Reports 2011
  • MS Access 2007

Reproducing the Issue

  1. Create a new report based on unique ODBC connection with Access File.
  2. Refresh the report it asks for login credentials for every record in the Access file.

Resolution

  1. Launch the ODBC data Source Administrator.
  2. Click on System DSN.
  3. Select the appropriate System Data Source Name.
  4. Click on Configure…
  5. ODBC Microsoft Access Setup window would pop up.
  6. Click on Advanced button.
  7. Provide the Login Name and Password under Default Authorization.
  8. Click on OK.
  9. Refresh the report it would ask only once for login credentials.

Keywords

Crystal Reports, CR, Login Credentials, ODBC Connection , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2011