Results 1 to 2 of 2
  1. #1
    ramkitty is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Posts
    8

    restrict access to tables and from editing form


    I have just finished my database (I think) minus some reports but how do I restrict direct data entry to tables and prevent users from modifiying the form.. data modification in the form would be fine though

    password protection would be ok.

    I would also like the form to open up on database opening

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    its a common request and a bit baffling that MS hasn't made it simpler to enact;

    in a form's property you will find:
    allowedits
    allowadditions
    allowdeletes

    these are properties you need to turn true/false.... how you implement it is situational...but you might want a table of users with a permission code...and then have them log in...and depending on who it is then when the form opens in the OnOpen event you can put those parameters to false...

    if you are not comfortable with any vba - and if you want to instead make different FEs for different people - then in the different FEs you could permanently make those changes...

    as for not allowing them into form Design View - you will want to remove that tool bar ; if you are designing Access you should have a text book of the version you use - available at any big book store or Amazon - - and any decent text book will have that instruction.....

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

Similar Threads

  1. Restrict Combo Box Options
    By KWarzala in forum Forms
    Replies: 1
    Last Post: 03-03-2010, 04:46 PM
  2. Editing a Linked Table
    By amndza in forum Access
    Replies: 2
    Last Post: 01-21-2009, 01:27 PM
  3. Replies: 0
    Last Post: 10-16-2008, 02:39 PM
  4. Restrict form access to certain people
    By DannyBoy7783 in forum Forms
    Replies: 2
    Last Post: 06-09-2008, 06:18 AM
  5. Form for Editing Only
    By Schwagr in forum Forms
    Replies: 4
    Last Post: 03-24-2006, 05:34 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