Results 1 to 5 of 5
  1. #1
    lqangel is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2015
    Posts
    6

    Preventing Accidental Changes/Deletion Lock/Unlock Fields using prompts

    Hello Everyone,

    This is my first post here and I'm still learning Access "behind the scenes" workings, but I am a quick learner!



    My company has an Access 2007.accdb database that we use to store client information and specifications. We then use word document merges to pull information into letter, notices, etc.
    We are on a shared server and have the "main" database file on the server, with the tables separate/linked in another database on that same server. Each of use who updates information in the database has a copy on our desktop we use to update. We have been having issues recently with people accidentally changing/deleting information (how someone can 'accidentally' delete an entire client is beyond me... there are prompts to prevent that). We have people who are going into the database for information (i.e. to look up a phone number, or address, etc.) and we are trying to stop that, but some people just don't listen... so anyway we want something to prevent changes unless we really did mean to make said changes.

    Is there a way to protect a form so that it can not be edited/deleted, but it is easy to say "yes I really do want to change that", possibly to have a prompt pop up and if we would like to remove the protection so we can edit we can do that? Maybe even a password required after said prompt?

    We basically just want a fail safe there so that if people are looking around for information (even though they shouldn't be) they can't accidentally mess something up.



    I hope that all made sense.
    Any help is greatly appreciated.


    -Ashley

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    open the form in READ ONLY mode:
    docmd.OpenForm "frmMain",,,,acFormReadOnly

    they cant change data.
    I have a tUsers table, it has their userID and rights code...User, Manager, Admin

    I get the userID via
    vUserID = = Environ("Username")
    then gets their code
    vUserRights = dlookup("[rights]","tUsers","[userid]='" & vUserID & "'")

    users get the default READ ONLY

    if vUserRights = "U" then
    docmd.OpenForm "frmMain",,,,acFormReadOnly
    else
    docmd.OpenForm "frmMain"
    endif

  3. #3
    lqangel is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2015
    Posts
    6

    Read-Only Form or Database?

    Is that the same as having the database files on their desktop as read only, because when I tried that it still let them edit fields due to the linked tables.

    Also, on that same note. If it is coded to be "read only" is there an easy way for someone to make theirs not be read only anymore? That way when they are truly trying to update data, they can.

    I will give it a shot none the less



    -Ashley

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    if a person knows Access in's and outs , one can bypass anything.
    But normal folks only know how to point ,click and type in data.

  5. #5
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    @lqangel
    Make sure your users are interacting with the data via forms. The way you are describing things, it seems users are opening tables to interact with the data.

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

Similar Threads

  1. Replies: 4
    Last Post: 03-16-2015, 10:31 AM
  2. Replies: 3
    Last Post: 01-26-2014, 06:32 PM
  3. Replies: 2
    Last Post: 02-29-2012, 12:51 AM
  4. Automatically Lock Fields
    By Toolman in forum Database Design
    Replies: 2
    Last Post: 05-27-2010, 10:36 AM
  5. Replies: 0
    Last Post: 03-08-2009, 05:12 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