Stop deletions

[354688]

If you create a select query is there anyway in which you are able to stop someone from selecting the results and inadvertently deleting the records from your database? I have several queries in my database and I don't really fancy creating forms for each one if possible.

 

[Remou]

If you use Select Distinct, the query cannot be updated.

 

[JerryKlmns]

Or if you have joins do them on the WHERE clause

SELECT Trnsct.*
FROM Trnsct, aa
where Trnsct.AitisiNo = aa.AitisiNo;