I have an access database that contains a list of usernames. The users are placed in this database when they "update" an in-house application. Basically the in-house update program will log the username along with a couple of other comma delimited values into a log file and a script will then disseminate the vales into the database. The problem is that when these users leave the company they remain in the database. the only way I know that they are gone is that I see that their last update was months ago and I then try to find their usernames in Active Directory. If they do not exist i purge them.
My question is how can I write a script within Access to query the usernames in the database against AD and then flag the users that no longer exist? I should like to point out that the "users" in my database are the actual valid Win NT user names.