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

Microsoft Office Access 2003

  1. Open the form in Design view.
  2. Double-click the form selector 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.

Show In 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.