Allow New Records but Prevent Edits in Microsoft Access Forms
Question details
Allow users to add records through a Microsoft Access form while preventing changes to existing records.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Users enter new data through a form but should not edit records that are already stored.
- Observed behavior
- The form should accept new records while keeping existing records read-only.
Identify the form users will use for data entry and confirm that its record source supports adding records. You need access to the form's Design View to change its properties.
Set the Access Form to Allow Additions but Not Edits
Use the form's Data properties to let users add records while preventing edits to existing records through that form.
In the Navigation Pane, right-click the form and select Design View.
Press F4 to open the Property Sheet, then select Form from the selection drop-down at the top.
On the Property Sheet's Data tab, set Allow Edits to No and Allow Additions to Yes. If users should not delete existing records through the form, also set Allow Deletions to No.
Save the form, switch to Form View, and try adding a new record and editing an existing one. Confirm that adding works and changes to existing records are blocked.

Use WPS Office for Everyday Document and Spreadsheet Work
WPS Office is a free, lightweight alternative for everyday office work, with a familiar interface and Microsoft Office format compatibility to support a smooth move for documents and spreadsheets. It does not replace Microsoft Access or enforce Access database permissions.

Frequently Asked Questions
Where are the Allow Edits and Allow Additions settings in Access?
Open the form in Design View, press F4, select Form in the Property Sheet, and open the Data tab.
Will these settings prevent users from editing the underlying table?
No. Form properties control behavior through that form, not direct table access or edits made through other forms and queries.
How can I prevent users from deleting records through the form?
In the form's Property Sheet, open the Data tab and set Allow Deletions to No.
Can I use a separate form just for new records?
Yes. Create a separate data-entry form and set its Data Entry property to Yes on the Property Sheet's Data tab. Existing records will not be displayed in that form, but the setting does not secure the underlying table.




