Results 1 to 3 of 3

password protect form

  1. #1
    nkuebelbeck is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Mar 2010
    Posts
    91

    password protect form

    so I have an 'admin' form that I need to password protect. I can think of a couple different ways to do this(without user level security, which I'm not prepared to do)

    Any recommendations?

    The form will be access via a switchboard. Better yet, if I could password protect a certain switchboard, than I could put all admin items on that board.

    Thoughts?



    Access 2010

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,222
    Do you want each user to have their own password? Need a table of users and passwords. If just one user (you), can build password in the code. Enter value into textbox. Code checks if match.

    If Me.textbox = "my password" Then

    Be aware, any minimally competent user with access to development tools can view the code.
    Last edited by June7; 01-15-2012 at 01:39 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    nkuebelbeck is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Mar 2010
    Posts
    91
    Thats kinda what I had already. Lucky for me they will be using the access runtime and won't have access to the code unless they take the file off onto another machine.

    Thanks!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Password protect a form
    By recon2011 in forum Forms
    Replies: 10
    Last Post: 11-18-2012, 04:36 PM
  2. Password Protect button on Switchboard
    By rosaj in forum Access
    Replies: 1
    Last Post: 08-04-2011, 11:08 AM
  3. Password Protect Forms
    By jlclark4 in forum Security
    Replies: 3
    Last Post: 01-25-2011, 04:26 PM
  4. readonly password protect
    By mlgehle in forum Security
    Replies: 1
    Last Post: 03-13-2010, 08:59 PM
  5. Password Protect Forms
    By Robert M in forum Programming
    Replies: 3
    Last Post: 01-15-2010, 01:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums