Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2008

    Unanswered: Securing a field in a table

    Hi everyone. My question is I have a table that holds the data for some test samples. One of the fields is the approval field which I would like to be entered by supervisors using passwords. I would like to make this a password protected yes/no field. Can anybody help me? How can I do this or can I?

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Are you trying to do this in a form or directly in the table? You can do it in a form but not in a table. Data entry should never be done directly into the table.
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Dec 2008

    Securing a field in a table

    I want to do this using a form but still don't know how to do it, can you help?

  4. #4
    Join Date
    Nov 2007
    Adelaide, South Australia
    In your BeforeUpdate event for the checkbox, prompt for a password. Set the Cancel property to True and Undo the checkbox field if the password isn't right.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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