DAO Error Code 0xc26

    Question by:
    On

    Topics:

    I am trying to use Crystal Reports 2008 SP1 with an Access database.  The Access database does not have a password when I open it, and I can view all the tables and fields.  When I open the database through Crystal Reports, it sees all of the tables however I can only use a few of the tables.  The rest of the tables gives me errors like the following:

    ---------------------------
    Crystal Reports
    ---------------------------
    Database Connector Error: 'DAO Error Code: 0xc26
    Source: DAO.Fields
    Description: Could not read definitions; no read definitions permission for table or query 'Contacts_Phone'.'
    ---------------------------
    OK  
    ---------------------------

    Good Question?
    0
     

    ?

    The member who asked this question verified this comment provided the solution that solved their problem.

    Accepted Solution on 2010-01-13 at 08:52:54ID: 26305743

    What version of Access?

    If 2003 or earlier (or the .mdb format), open Access, then click Tools - Security - User and Group Permissions, then select the Table that you want to review and check the Owner tab. It should be listed as Admin. If it's anything else, you may try to build a new, blank database and import everything into that new databse. This should change the Owner back to Admin.

    Top Expert Contributor

    Essential articles and videos from the Experts

    More valuable questions with Expert answers

    201511-LO-Qu-074

    Extend your technology team with the Experts Exchange community.

    — trusted by —

    Who answers my questions?Our community has technology experts around the world.

    Rey Obrero

    Expert in:

    • MS Access
    • Query Syntax
    • Visual Basic Classic
    • Databases
    • MS Applications

    Gustav Brock

    9

    Articles

    Expert in:

    • MS Access
    • Query Syntax
    • Databases
    • Visual Basic Classic
    • .NET Programming

    Dale Fye (Access MVP)

    9

    Articles

    Expert in:

    • MS Access
    • Query Syntax
    • MS Applications
    • MS Development
    • MS Office

    Jim Dettman (Microsoft MVP/ EE MVE)

    7

    Articles

    Expert in:

    • MS Access
    • MS Applications
    • Databases
    • MS Development
    • MS Office

    PatHartman

    Expert in:

    • MS Access
    • Databases
    • MS Applications
    • MS Excel
    • MS Office

    crystal (strive4peace)

    Expert in:

    • MS Access
    • MS Excel

    Nick67

    8

    Articles

    Expert in:

    • MS Access
    • MS Applications
    • MS Development
    • MS Excel
    • MS Office

    Scott McDaniel (Microsoft Access MVP - EE MVE )

    Expert in:

    • MS Access
    • Query Syntax
    • Visual Basic Classic
    • Databases
    • MS Applications

    GrahamSkan

    3

    Articles

    Expert in:

    • MS Word
    • Visual Basic Classic
    • MS Office
    • MS Access
    • MS Applications

    RELATED TOPICS view all topics

    1. Query Syntax
      (46,074)
    2. Visual Basic Classic
      (162,810)
    3. MS Applications
      (44,146)
    4. Databases
      (52,987)
    5. MS Excel
      (125,088)
    6. MS Office
      (55,901)
    7. MS SQL Server
      (154,646)
    8. MS Development
      (48,689)
    9. VB Script
      (35,477)
    10. MS SQL Server 2005
      (71,588)