Specify whether a user can add, edit, or delete a record

ShowIn a form

  1. Open the form in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).
  2. Double-click the form selector (form selector: The box where the rulers meet, in the upper-left corner of a form in Design view. Use the box to perform form-level operations, such as selecting the form.) to open the form's property sheet.
  3. Do one or more of the following:

To prevent additions, set the AllowAdditions property to No.

To prevent edits, set the AllowEdits property to No.

To prevent deletions, set the AllowDeletions property to No.

ShowIn a data access page

  1. Right-click the section bar of a section that belongs to the group for which you want to set properties, and then click Group Level Properties.
  2. Do one or more of the following:

    To prevent additions, set the AllowAdditions property to False.

To prevent edits, set the AllowEdits property to False.

To prevent deletions, set the AllowDeletions property to False.

 Note   The default setting of the properties in pages created using Access 2002 or later is True. In pages created using Access 2000, the properties are, by default, set to False. You can open a page created using Access 2000 in Access 2002 or later and set the properties to True.

 
 
Applies to:
Access 2003