Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2011
    Posts
    20

    Post Field Level Permissions in MS Access 2003

    Im doing a project in access which i have tables and forms. I have applied user secuity in my project.In that, some users have All permissions to insert,update and delete the data and some user has only insert permissions and doesnt have any other permissions.



    I have 10 different fields in my form.

    My Requirement is for non editable users, they cant able to edit the record once they inserted. But i need to allow only two columns to edit say an example, I have a dropdown field named Status with two options Open and Close and a Text Box Named Closed Date.If they Select Open from the dropdown, then i need to give edit permissions for Status and Closed Date fields only.. After inserting the record and again once they select the Close Option in the dropdown field, then the entire record should goes to Read-Only. Is it possible to do like this??

    Please Suggest me..

    Thanks

  2. #2
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    186

    Field Level Permissions in MS Access 2003

    When the User has only Insert authority on the table he cannot be allowed to edit selective fields on the Form. If he has edit authority on the table then on the Form we can identify the current User and lock all the fields while opening the form through VBA.

    If he is trying to create a new record (current event) then unlock all the fields for data entry and lock all the fields on the update event.

    On Click Event of Status and Close Date, unlock the fields for editing and lock again on the update event.

    If you have several Users of this kind then you may create a Group Account for them and assign permissions on the Group Account rather than for each User.

    Current User's Group Name can be checked with statement like:
    Code:
    IF dbengine.Workspaces(0).Users(currentuser).Groups(0).Name = "NoEditgrp" then
    'Rest of the procedure
    End If
    http://www.msaccesstips.com/2010/03/...ount-with-vba/

    http://www.msaccesstips.com/2006/11/...cess-security/
    http://www.msaccesstips.com (Learn MS-Access Tips and Tricks)
    Learn Advanced MS-Access Programming with examples and VBA.

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

Similar Threads

  1. Access 2003 automatic field entry
    By RANCHLAW56 in forum Forms
    Replies: 6
    Last Post: 12-30-2010, 02:57 PM
  2. BUG! Field level date validation
    By buj in forum Forms
    Replies: 0
    Last Post: 09-16-2010, 08:23 PM
  3. Field Level Access
    By botts121 in forum Programming
    Replies: 0
    Last Post: 07-09-2009, 11:59 AM
  4. Access permissions
    By paulbrog in forum Access
    Replies: 1
    Last Post: 05-05-2009, 11:14 AM
  5. Field Level Date validation
    By fadone in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 10:23 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
  •  
Tech Forums: Microsoft Office Forums