override the value in table/query when I delete the value

[SK]

How do I prevent to deleting values in Query?
When I deleted one value from from the query output data, it deletes the
value from table also. I don't want to change any values in output file. How
do I prevent to editing values from query?

 

[John W. Vinson]

How do I prevent to deleting values in Query?
When I deleted one value from from the query output data, it deletes the
value from table also.

Of course. The query has no independent existance; it's just a "view" of the
data in the table. If you delete a record, or edit a field, or make any change
in the data in a query, you're making the change in the table, because the
data exists only in the table.

I don't want to change any values in output file. How
do I prevent to editing values from query?

Use a Read Only query, for example by viewing the query's Properties and
setting its Recordset Type to "Snapshot".