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

  • Thread starter Thread starter SK
  • Start date Start date
S

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?
 
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.
Click to expand...

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?
Click to expand...

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