Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2010
    Posts
    36

    Unanswered: How to lock table in ms access

    Dear members;

    i want to lock a table in my access 2007 database that the user are not able to edit the contents of the table.

    is there any way?

    thanks

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    Can't lock them other wise your user won't be able to add/edit the data............

    But a dirty trick you can do is hide the table then set msaccess to hide hidden objects

    Have done many time I do to queries to and to one that user should not be running.

    What they can't see the can't ......
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    And, of course, if this is a multi-user database, it absolutely needs to be divided into a front end/back end configuration, with the Tables in the back end and everything else in the front end. A copy of the front end then needs to be on each user's hard drive with the back end on a server of some sort.

    With it split, the users can't access the tables from within the front end file.

    As with all security matters, it depends on the skill set/level of the persons you're trying to secure it from.

    On a single-user db, when all you're trying to do is keep some bored user from diddling with the Tables directly, hiding the Tables is probably enough.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Feb 2011
    Location
    Miami, Florida
    Posts
    10

    Oslin VIIIA

    As long as you are using access,

    I don't think there is a way to lock a table from an enthuthiast. May be right clicking on it and hiding it may do the trick.


    Thanks
    Manish

  5. #5
    Join Date
    Sep 2012
    Posts
    5
    how to set password in ms access 2003 design

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •