Results 1 to 4 of 4
  1. #1
    neuhur is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2014
    Posts
    11

    Adding A Password To Update/Edit Data In A Form

    Hello Everyone,



    I have a form in which I used the button wizard to add a record and delete a record. I want to add a button that will allow the user to update/edit a record; however, I want the user to be required to enter a password in order to make updates/edits to data that is in the form.

    Please let me know what is the easiest way to accomplish this.

    Thanks in advance for your help.

    Neuhur

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Do some research on Login form using a password.
    I recommend you do NOT delete records physically.
    In your design include a boolean(Yes/No) field that indicates
    -- Yes is logically deleted
    -- NO or null/blank is active

    Make sure your queries and procedures make consistent use of the boolean when working with records.

    Good luck with your project.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Are you going to publish db as accde file?

    Are you aware that holding down shift key when opening accdb file will override option settings and bypass Autoexec macro and the db will be fully accessible? What I am saying is you can do this passwording but it is easily subverted. So what is the reason for it?
    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.

  4. #4
    neuhur is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2014
    Posts
    11
    Thanks for the info!

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

Similar Threads

  1. Replies: 0
    Last Post: 03-13-2012, 12:57 PM
  2. Replies: 3
    Last Post: 12-19-2011, 11:18 AM
  3. Edit Data and Recalculate WITHIN THE FORM ONLY
    By AusStiffler in forum Forms
    Replies: 3
    Last Post: 10-19-2010, 04:32 AM
  4. How to edit data in a form
    By x3ldonx in forum Forms
    Replies: 2
    Last Post: 10-11-2010, 01:20 AM
  5. Most reliable way to edit form data in VBA...?
    By samalter in forum Programming
    Replies: 0
    Last Post: 06-23-2006, 12:39 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
  •  
Other Forums: Microsoft Office Forums