Results 1 to 5 of 5
  1. #1
    avarusbrightfyre is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Sep 2009
    Posts
    60

    Is there a way to mimic user level security in 2007?

    I have developed a database that tracks events. I'm setting it up so that we can receive a request for an event and route it up through several people and eventually up to our boss, all electronically within the databse, but I would like to have certain things disabled for certain users. For example:



    I want to set it up so that once the boss makes a decision as to whether we'll support the event, an email is automatically sent informing the requesting party of the decision. Now I obviously don't want just anyone to be able to click that button and send and email, so I need to make sure that only the boss can click the button.

    So, first, is this even possible, and second, how do I go about doing it without some kind of "user level security"? Is it possible to access the user name logged in to the computer and use that to disable things?

  2. #2
    ketbdnetbp is offline Competent Performer
    Windows 7 32bit Access 2003
    Join Date
    Mar 2011
    Location
    Midwest
    Posts
    254

    avarusbrightfyre -

    This might be of some help...


    https://www.accessforums.net/code-re...mple-7538.html

    All the best,

    Jim

  3. #3
    avarusbrightfyre is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Sep 2009
    Posts
    60
    I'm not ultra familiar with the more complex code in access; guess you could say I'm at the "intermediate" level of this stuff. Is LoginID a standard function that access can use, or is there some code in there I'm not recognizing that figures out the loginID from windows and sets it as a value in access?

  4. #4
    ketbdnetbp is offline Competent Performer
    Windows 7 32bit Access 2003
    Join Date
    Mar 2011
    Location
    Midwest
    Posts
    254

    avarusbrightfyre -

    I haven't encountered LoginID as a standard function. I think the function on PKStormy's demo is getuser()?

    Here's another possibility...

    http://access.mvps.org/access/api/api0008.htm

    Lastly, you might try...

    Public Function GetUser() As String
    GetUser = Environ("UserName")
    End Function


    However, I haven't used it before.

    All the best,

    Jim

  5. #5
    avarusbrightfyre is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Sep 2009
    Posts
    60
    Thanks, I'll give those a try.

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

Similar Threads

  1. Get User Automatically and Security Level example
    By pkstormy in forum Code Repository
    Replies: 2
    Last Post: 12-10-2015, 12:11 PM
  2. Alternative to user level security?
    By alsaf in forum Security
    Replies: 4
    Last Post: 08-20-2011, 03:19 AM
  3. Replies: 1
    Last Post: 08-13-2011, 04:44 AM
  4. Replies: 8
    Last Post: 06-30-2010, 10:57 PM
  5. User level security question
    By genesis in forum Security
    Replies: 1
    Last Post: 07-08-2009, 10:10 AM

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