In the zipped database, login as user John with password john and open the client form. John has a user level of Admin and should not be able to delete a record. Delete is turned off properly until you click in one of the selection boxes at the top of the form and then click on the (locked) main body of the form at which point delete is enabled again. I cannot for the life of me track down what event is allowing this to happen or how to make it stop which is quite crucial for me. The social workers I am working for are quite willful in finding new ways to get around security.
There are many many things that won’t work on this form, all the extra stuff has been included to stop all the error messages that will occur if they aren’t included. (And, yes, I know the one-to-one design of tblNewcomer to tblISAP is inefficient but there are historical reasons for this and almost 200 queries that are based on this design. The thought of making it more efficient is too horrible to contemplate! 
)
You will need to have the Mousehook.dll file in the same folder or you will get error messages.
