Results 1 to 3 of 3
  1. #1
    kieranharrison is offline True blue Aussie m8
    Windows 10 Access 2016
    Join Date
    Jun 2019
    Location
    Queensland, Australia
    Posts
    28

    Question How to protect a table

    Can anyone please help me, I want to protect some tables in Access 2016. I can see a few ways on Google on how to do this but none of them work for me.



    I just want to password protect a few critical tables so that people don't mess them up.

    Thanks,

  2. #2
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    367
    There is no sure fire way to protect a table unless you are using SQL Server. Perhaps you should explain what exactly you are protecting the tables from as your Users should be interacting with the data via Forms.
    Gina Whipp
    Microsoft MVP (Access 2010-2015)
    https://www.access-diva.com/tips.html

  3. #3
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,993
    Suggest you read this article for advice on securing your database http://www.mendipdatasystems.co.uk/i...ity/4594461803
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

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

Similar Threads

  1. Replies: 29
    Last Post: 07-27-2019, 12:39 AM
  2. lock web app to protect it
    By sup in forum SharePoint
    Replies: 1
    Last Post: 04-13-2016, 06:10 PM
  3. Replies: 1
    Last Post: 02-01-2013, 07:48 PM
  4. Help protect my database
    By eduardo in forum Security
    Replies: 1
    Last Post: 06-26-2012, 12:55 PM
  5. Upldate password protect linked table
    By snoopy2003 in forum Security
    Replies: 1
    Last Post: 03-18-2011, 12:43 AM

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