Results 1 to 3 of 3
  1. #1
    Join Date
    May 2014
    Posts
    35
    Provided Answers: 2

    Unanswered: Restrict who can view tables

    I know I don't have lots of information to give, but I don't know where to start. I have a data base that contains sensitive information. I have a Form to enter data into a table works great. The problem is that I now have users that need to input records, but can not have access to see the records. When those users with limited access open the database they need to only see the input form.

    If anyone could help get going in the right direction I would be grateful.

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    496
    Provided Answers: 24
    I have a tUser table, with userIDs and accesses to forms.
    The main form opens, grabs their user Id. Then enables buttons, or forms depending on the rights given.
    Otherwise closes the database.

    Sub Form_load()
    sUserID = Environment("UserName")
    SLevel = Dlookup("Level","tUsers","[userID]='" & sUserID & "'"
    BtnClients.enabled = sLevel ="C"

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    For those 'data input only' users, either only allow them access to a Form where Data Entry Property is set to Yes...or open the appropriate Form using code like this:

    DoCmd.OpenForm "YourFormName", , , , acFormAdd

    Both ways only allow the adding of New Records, without allowing existing Records to be seen.

    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

Posting Permissions

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