How do I stop a table from deleting records?

M

M-Explorer

I have a table that is part of a query. The table includes 45 rows of data
(it's actually a rating scale). Randomly, rows of data disappear. There
isn't any pattern to which ones disappear. Any idea why this is happening?
How can I prevent this problem? I'm using Access 2003.
 
G

Guest

I fixed that problem by implementing security and removing
the delete permission. No-one was aware that they were
deleting records, and removing the delete permission was a
waste of effort(!), but magically with minutes of removing
the delete permission one of the users was complaining that
the application didn't work correctly......

(david)
 
Top