Solved

DAO Error Code 0xc26

Posted on 2010-01-13
1
1,372 Views
Last Modified: 2013-11-29
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  
---------------------------
0
Comment
Question by:keithslater
1 Comment
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 250 total points
ID: 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.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Read about achieving the basic levels of HRIS security in the workplace.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question