I have a database in Access97 that automatically detects the NT userid. I would like to use this information to set the current user.
In other words, I don't want my users to have to logon, instead I want to create users in access with their NT userid's, then detect the NT id at logon and compare it to the user name in the users list, if the name does not exist, I'd like to either log the person on as guest or kick them out of the database.
If I can implement this, no passwords will be necessary because detecting the NT userid would authenticate.
If I cannot do that, can I at least allow users to logon as guest (or whatever), then detect their userid's and somehow programatically change the current user to the NT id?
Any help at all would be appreciated.