Solved

DAO Error Code 0xc26

Posted on 2010-01-13
1
1,390 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
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.

710 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