How to set a query cannot delete?

[cheer]

I have a VBA code as below. How to set a query which cannot delete, but can add and update ?

Private Sub cmdEdit_Click()
DoCmd.OpenQuery "V_Master_Drawing_Assembly", acViewNormal, acEdit
End Sub

 

[Galaxiom]

Display the results in a form where there are properties to control what can be done to the records.

A user should not be interacting directly with a query or table.

 

[spikepl]

Tables and queries are for storage and behind.the-screen manipulation of data only.

Users should only have access to data via forms and reports, where you can implement logic to do whatever you want. So base a form on your query, to only change/add data