Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    The form opens with deletions allowed for me. I don't know why.

  3. #3
    4 Star Lounger
    Join Date
    Dec 2002
    Location
    Kitchener, Ontario, Canada
    Posts
    421
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='794212' date='21-Sep-2009 02:03']The form opens with deletions allowed for me. I don't know why.[/quote]

    I found the problem, too stupidly obvious to go looking there in the first place. The Immigration Status subform had Allow Deletions set to Yes in the properties window. Once I changed that, the form was locked or unlocked according to permissions in the VBA.

    Thanks for looking at it anyways.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Thanks for posting the solution.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •