ACC2000: Can't Add, Edit, or Delete Records on Data Access Page

Article ID: 201990 - View products that this article applies to.
This article was previously published under Q201990
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

Expand all | Collapse all

SYMPTOMS

You are not able to add a new record, or to edit or delete an existing record on a data access page.
Back to the top | Give Feedback

CAUSE

You may experience this problem if any of the following conditions are true:

  • The page's data source does not have a primary key, unique constraint, or unique index.

    -or-
  • There is not a primary key, unique constraint, or unique index in the schema of the page.

    -or-
  • The page does not have a Record Navigation control.
Back to the top | Give Feedback

RESOLUTION

To resolve this problem, take the appropriate action from the following list of items:
  • Add a primary key, unique constraint, or unique index to the page's data source.
  • Add the primary key, unique constraint, or unique index to the schema of the page.

    To add one of these fields to the schema, add a primary key, unique constraint, or unique index field to the design of the page. This automatically adds the field to the page's schema. If you do not want this field to appear on the page, delete it from the page; it remains in the schema.
  • Add a Record Navigation control to the page.
Back to the top | Give Feedback

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Back to the top | Give Feedback

MORE INFORMATION

To see if the page schema has a primary key, unique constraint, or unique index click the Page tab of the Field List, and then look through the tree structure for one of these fields.
Back to the top | Give Feedback

REFERENCES

For more information about Primary Keys, click Microsoft Access Help on the Help menu, type primary property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about Unique Indexes, click Microsoft Access Help on the Help menu, type unique property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about the CONSTRAINT Clause, click Microsoft Access Help on the Help menu, type constraint clause in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about inserting a Record Navigation control, click Microsoft Access Help on the Help menu, type add a record navigation control to a data access page in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Back to the top | Give Feedback

Properties

Article ID: 201990 - Last Review: July 16, 2004 - Revision: 1.2
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbdap kbprb kbpending KB201990
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top