SAP Knowledge Base Article - Public

1206858 - Error: 'Logon failed', when creating a report off MS Access 2007 and above, using the MS DAO connection, in Crystal Reports

Symptom

  • Error: Logon failed.
  • Unable to connect to MS Access 2007 or higher from Crystal Reports.
  • Crystal Reports cannot connect to an ACCDB file format of MS Access 2007 or higher using a MS DAO connection.
  • When attempting to connect to a MS Access 2007 or higher database from Crystal Reports using a MS DAO connection, get the error:
    •  
    • Logon failed
    • Details: DAO Error Code: 0xd0f 
    • Source: DAO.Workspace
    • Description: Unrecognized database format '<File path>\<File name.accb>'
 

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
           
  • MS Access 2007
  • MS Access 2010
  • MS Access 2013
  • MS Access 2016

Reproducing the Issue

  1. In Crystal Reports, create a new report using the connection: Access/Excel (DAO)
  2. In the Access/Excel (DAO) window, select your MS Access database file: <File Name.accdb>
  3. Select the Database Type: Access
  4. Click on the button "Finish"
     
    Get the error: Logon failed

Cause

  • Microsoft Access 2007 and higher database files (ACCDB files) are of a different format from previous version of MS Access database. ( MS Access 2003 and below )
      
  • Microsoft Data Access Objects (DAO) does not support access to ACCDB files, and this is why you are receiving an error when attempting to connect to MS Access 2007 or higher.
 

Resolution

  • To report off a MS Access 2007 database or higher ( accdb format ) use an ODBC connection using the Microsoft Access Driver (*.mdb,*.accdb) 
           
    1. Confirm you have the Microsoft Access Driver (*.mdb, *accdb ), if not install MS Office 2007 or higher 32bit, or the MS Access Redistributable 32bit to install the driver.
            
      1.1  Launch the Microsoft ODBC Data Source Administrator (32bit)
             
      1.2  Under the tab "Drivers", confirm you have the driver: Microsoft Access Driver (*.mdb, *.accdb )
             The ODBC driver is installed on your computer when installing the 32bit version of MS Office 2007 or higher.

              ODBC Driver MS Access.png

         
      If you do not see the MS ODBC driver, then it is because you either have the 64bit version of MS Office installed, or does not have MS Office installed.
        
      To install the MS Access Driver, you can:
      - Install the 32bit version of MS Office 2007 or higher on your computer, or
      - Download and install the MS Access Database Engine Redistributable available on the Microsoft website at:
       
         https://www.microsoft.com/en-ca/download/details.aspx?id=13255

      The above download will install the Mircrosoft Access ODBC driver, it will have the 32bit and 64bit version of the ODBC driver. Crystal Reports requires the 32bit version.
                    
           
    2. Still in Microsoft ODBC Data Source Administrator (32bit), create an ODBC DSN using the Microsoft Access Driver (*.mdb,*accdb), to your MS Access 2007 or higher database.
                
    3. In Crystal Reports, create a new report using an ODBC connection to the ODBC DSN created in the previous step.

Keywords

CR2008 CR 2008 XIR3 XI R3 XI3.0 XI3 3 3.0 TITAN RN , 9508971, MS Access 2007, DAO , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016