Query which isn't read only but is protected from deleting records

[Goose]

Hi!

It would be great if someone could help me out with this question:

All the queries on our database have been made read only to avoid
disasterous deleting mistakes.

I would like staff to be able to change data in query view - but I am
worried by the fact that people could delete rows accidently (or even all the
rows in a query if they were for example trying to copy the data and
accidently hit control x instead of 'control c').

Is there any way that you can have a query which is not read only - so you
can go into fields and type/delete - but where you cannot delete entire rows?


Can you somehow block the grey squares to left hand side that let you
highlight a row? Or at least alter the "Are you sure you want to delete?"
dialogue box so the default option is 'no' not 'yes'? Or some other solution?

 

[Clifford Bass]

Hi Goose,

A datasheet form with Allow Deletions set to No should do the trick.

Clifford Bass