Results 1 to 3 of 3
  1. #1
    Join Date
    May 2014
    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
    Provided Answers: 23
    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
    Richmond, Virginia USA
    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 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