Results 1 to 5 of 5
  1. #1
    aligahk06 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2010
    Posts
    94

    Can i lock our records in ms access database

    Dear All,



    I want to lock our few records in a table so that no one can accidentally edit the record.

    is there any way to do this ?

    Thanks ..

    aligahk06

  2. #2
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    You should not allow users to edit data in the tables.

    You should allow the user to View the records in a Form.

    In the Form you can set the Control Properties to Enabled = No & Locked = Yes
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Or you can simply set the form recordsource type to snapshot if you want to lock the whole form, rather than locking each and every control.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    As both previous responders have stated, users should never work with tables but only interact with data via forms.
    But in direct answer to your question, tables cannot be locked other than when opening a database read only.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    agree with previous comments - keep users away from tables, only use forms/reports. Another option might be if the users can edit only some records and do not need to see the records in a form is to exclude them in the form recordsource (record might have a field called say 'editable').

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

Similar Threads

  1. Replies: 5
    Last Post: 11-13-2017, 02:09 PM
  2. Replies: 2
    Last Post: 04-27-2017, 09:08 PM
  3. Lock individual records after saving
    By DOC666 in forum Access
    Replies: 3
    Last Post: 05-05-2014, 02:54 PM
  4. Replies: 2
    Last Post: 01-28-2013, 04:42 PM
  5. Replies: 11
    Last Post: 07-17-2011, 08:56 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