Knowledge Base

ACC2: Preventing Users from Adding New Records

Article ID: 112725

Article Last Modified on 7/8/2002

APPLIES TO

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.

Keywords: kbinfo kbusage KB112725


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.