Microsoft KB Archive/112725

= ACC2: Preventing Users from Adding New Records =

Article ID: 112725

Article Last Modified on 7/8/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



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.

