Results 1 to 8 of 8

Thread: Security

  1. #1
    Join Date
    Apr 2004
    Posts
    100

    Unanswered: Security

    Hello,

    I am using MS Access 2003 with some forms that represent my ER-Model.
    Now I am wondering if its possible to show certain fields only to certain users.
    What possibilities do I have in that respect?

    Regards,
    Proximus

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    You meant fields on the From or in the table?

  3. #3
    Join Date
    Apr 2004
    Posts
    100
    either one.
    which method would be more safe and which one easier to implement?
    Thanks for your help!!

  4. #4
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    If you want to do that on the form, there is a function called CurrentUser which tells you who is loged in. Ypu can use this function like that
    PHP Code:
      if  CurrentUser ="the log name of your users"   Then' i.e  "McDonlad" 
         txt_box1.Visible=false
      else
         txt_box1.Visible=True  
      Endif 

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    If you want to do that on the Table level, so you can hide the DB Window (this will be for all users)

  6. #6
    Join Date
    Apr 2004
    Posts
    100
    Thank you very much for your quick help !!!!

  7. #7
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    No problem, you are welcom, did you try it....

  8. #8
    Join Date
    Apr 2004
    Posts
    100
    hey,

    I have tried to hide certain fields to certain users. With success.
    However, I am still wondering whatelse is possible in Access 2003 with respect to security. Could someone provide me an overview with the possibilities? Thanks a lot in advance.

    Regards,
    Proximus

    question:
    when createing a new user and adding it to a group, is it then possible to restict viewing/editing of certain attributes within a table or is it limited to set the permissions to the whole table?
    Last edited by Proximus; 04-30-04 at 12:05. Reason: new question arose

Posting Permissions

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