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?
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?
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?
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