ACC2: Preventing Users from Adding New Records (112725)


The information in this article applies to:

  • Microsoft Access 2.0
This article was previously published under Q112725
Moderate: Requires basic macro, coding, and interoperability skills.

SUMMARY

In Microsoft Access version 2.0, you can use the DefaultEditing property to prevent users from adding new records but still allow them to edit existing records.

MORE INFORMATION

There is a new value for the DefaultEditing property in Microsoft Access version 2.0 called "Can't Add Records." The following example demonstrates how to use this value to prevent users from adding new records:
  1. Open the sample database NWIND.MDB.
  2. Open the Employees form in Design view.
  3. If the property sheet is not displayed, display it by choosing Properties from the View menu.
  4. In the property sheet, select Other Properties.
  5. Change the DefaultEditing property to Can't Add Records.

REFERENCES

For more information about the DefaultEditing property, search for "DefaultEditing," and then "AllowEditing, DefaultEditing Properties" using the Microsoft Access Help menu.
Modification Type:MajorLast Reviewed:7/8/2002
Keywords:kbinfo kbusage KB112725
©2002 Microsoft Corporation. All rights reserved.