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:
- Close the Crystal Report.
- Click Start>>Run.
- Copy and paste the following in the Run dialog box
Regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll
- Click "OK".
- After clicking "OK" a message box will appear showing successful registration of the dll.
- 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 Business View Manager , Problem
Product
SAP Crystal Reports XI ; SAP Crystal Reports XI R2