Permission & Access Issues

Allow New Records but Prevent Edits in Microsoft Access Forms

Bushra ParveenBushra Parveen Nov 22, 2026 868 views

Question details

Allow users to add records through a Microsoft Access form while preventing changes to existing records.

Allow New Records but Prevent Edits in Microsoft Access Forms
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the form in Design View

In the Navigation Pane, right-click the form and select Design View.

2
Open the form properties

Press F4 to open the Property Sheet, then select Form from the selection drop-down at the top.

3
Change the data settings

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.

4
Save and test the form

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.

Set the Access Form to Allow Additions but Not Edits
Form settings are not database security: These properties apply only to this form. They do not prevent users from changing data directly in a table or through another form or query. Control access separately if users must not bypass the form.
Free Microsoft Office alternative

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.

Create and edit documents and spreadsheets in a familiar interfaceWork with Microsoft Word DOCX and Excel XLSX filesUse spreadsheet tools for data entry and review alongside your Access workflowGet a free, lightweight office suite
microsoft office alternative - wps office

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.