Preventing data deletion

[garywood84]

I have developed a database in Access which has user permissions implemented. These are set so that only Full Data Users have permission to delete information.

However, it has come to my attention that users can get around this by creating a query and then deleting records displayed in its results. I can't understand why this is possible, because the permissions should prevent this.

Can anyone help?

Thanks,

Gary

 

[rsmonkey]

In the MSDE 2000 User Logins and Permissions Manager make sure the Read only user have db_datareader permissions chk box ticked and nothing else..