Microsoft KB Archive/208586

= ACC2000: How to Prevent Users from Adding New Records =

Article ID: 208586

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208586



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SUMMARY
In Microsoft Access 2000 you can control the user's ability to add records to a table when using a data entry form. The AllowAdditions property can prevent users from adding new records while still allowing them to view and modify the existing ones.



MORE INFORMATION
You can set the AllowAdditions property under the Data tab of the form's property sheet. The default setting is Yes (True or -1), and this setting allows the user to add new records. If you set this property to No (False or 0), the user cannot add new records. The No setting disables the New Record indicator on the toolbar and the Data Entry command on the Records menu.

The following example demonstrates how the AllowAdditions property works.

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

 Start Microsoft Access and open the sample database Northwind.mdb. Open the Customers form in Design view. If the property sheet is not displayed, on the View menu, click Properties to display the form's property sheet. In the Form property sheet, click the Data tab, and then set the AllowAdditions property to No. Add a command button to the Customers form. Set the command button's OnClick property to [Event Procedure], and then click the Build button to the right of the OnClick property box. Type the following statement in the Form_Customers module:

Forms!Customers.AllowAdditions = True

</li> Close the Form_Customers module and save the Customers form.</li> Open the Customers form in Form view.

Note that Record on the Insert menu and the new record selector are disabled. You cannot add any records. However, if you click the command button, note that the new record options are enabled.</li></ol>

<div class="references_section">