How do I stop a table from deleting records?

[Guest]

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.

 

[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)

 

[Guest]

Thanks. I made the change. We'll see what happens!