Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Apr 2002
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Password Protect a Field (2000)

    Hi,
    Was wondering if there is a quick way to password protect just one field on a form? Or have that form available for editing by only one person. The database is used by several people at the same time.

    Thanks,
    Russ

  2. #2
    Lounger
    Join Date
    Apr 2002
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Protect a Field (2000)

    Well this is what I did... I locked the field and then made an innoculous location that if clicked will unlock the field. Then only told the person who will use the field where to click. When you exit the field it locks again. But I'd still like to know if there is a more secure way of doing it.

    Russ

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Password Protect a Field (2000)

    Using Access security will allow you to define groups and users and determine which user can do what in the database. An alternative is to create a separate front end for administrative use and use network permissions to restrict who can see the folder that contains that front end.
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Protect a Field (2000)

    If it's a case of keeping honest people honest (as opposed to keeping hackers out), use BeforeUpdate event code to call InputBox and request a password. If the password is wrong, display a nasty message and set Cancel to true. Don't forget to create an MDE so that users can't look at your code.

  5. #5
    Lounger
    Join Date
    Apr 2002
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Protect a Field (2000)

    I'll try that. Thanks, Russ

Posting Permissions

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