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

    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 ..


  2. #2
    mike60smart is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2018
    Living in Scotland UK

    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

  3. #3
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Ontario, Canada
    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.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  4. #4
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Somerset, UK
    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 (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  5. #5
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    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 - Senior Forums