Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2006
    Posts
    30

    Exclamation Unanswered: User Login for Access 2007

    Is there an add-in or coding for user login similar to 2003 and prior? I can create a user login table on our sharepoint site but that can have its own set of problems. Does MS have another method for user contol for Access 2007?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    No.
    ........
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jul 2006
    Posts
    30
    That's clear. Any idea why MS did this?

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I believe they said that the security was too weak anyway or something.

    I personally believe they just didn't have time to make it work, so they rushed it to meet production schedules. There were a lot of ticked off developers over Access 2007.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Jul 2006
    Posts
    30
    Thanks for the insite. While we care about security, we are more concerned about tracking who does what in the database. When we find data is entered incorrectly, we can easly track who needs additional training. We can have them enter a user code, but they do not always do so or can enter another user's code. One work around we found is to create a small login table in our hosted sharepoint site and link it to the database. This works but has its own set of problems. Does Access 2007 have function that can extract the Windows login user name or the workgroup login user name?

  6. #6
    Join Date
    Jul 2006
    Posts
    30
    Another thought.. I think can accomplish capture of user login by adding a required entry field to the switch board. I can also capture the login time and date at the same time. Is there a way to automatically update a user login table when the user logs out? That is to close the login table when the user clicks Exit or disable the Exit button and replace it with a Log Out Button?

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You can do whatever you want. I often use my own logins -- custom login dialog boxes and a user management area. You can then code your forms to react to who is logged in and maybe what their userlevel is. Sky is the limit, but you have to do all the work
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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