1199108 - When connecting to MS Access/Excel using native connection the following error occurs: Logon failed. Details: DAO Error Code. Source: DAO. Workspace

SAP Knowledge Base Article - Public

1199108 - When connecting to MS Access/Excel using native connection the following error occurs: Logon failed. Details: DAO Error Code. Source: DAO. Workspace

Symptom

Open CrystalReports. Double click "Create New Connection". Select "Access/Excel (DAO)" Choose Access and select the Access file. Click Finish. After clicking the Finish the following error occurs:

Logon failed. Details: DAO Error Code. Source: DAO. Workspace

Cause

The error occurs as the DAO360.dll is not registered properly.

Resolution

Yes, it is possible to overcome this error message. The error occurs as the DAO360.dll is not registered. As soon as the mentioned dll is registered connecting to Access/ Excel using native connection is done without any issues.

In order to overcome the issue follows the following steps:

  1. Close the Crystal Report.
  2. Click Start>>Run.
  3. Copy and paste the following in the Run dialog box

Regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll

  1. Click "OK".
  2. After clicking "OK" a message box will appear showing successful registration of the dll.
  3. Now open CR XI and try to create new reports.

Keywords

DAO, workspace,Logon failed DAO Error Code , 4607272 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2