Well, more like taking the Windows login username and password and having it authentication with the server when they try to login into the database application.
for instance. I login into Windows XP desktop using my assigned ID and password underthe company's domain server.
Now i want to be able to create a login script that will use the same ID and password pulled from the domain server. That way when the system requires a password change, it will also change the users password for the application.
Uh, the standard security solution for this situation is to just put the database on a network folder, and allow access to only a few people. These people "put in their password" when they log into Windows, then that authentication allows them access to the folder.
You are correct. The database back-end is located on a shared Network drive. The front-end is located locally on the users workstation. Due to corporation policy. all network applications, need to have a seperate user authentication process. I was asked if it was possible to have the application authentication process coincide with users network login.
In other words, when the user tries to login into the application. The users name and pass is authenticated against the network username and password. A way to get the username and password to authenticate with the domain server.
Ask them if you have to put in a password whenever you open a Word document. Argue Access doesn't count; they've got to bend. That's an unusual policy.
Of course I don't know where you work so maybe it's not unusual given your industry. Good luck.
Any password you pop up/verify doesn't actually carry any security along with it--you can probably figure out how to check their password, but you can't really lock it down if they get the password wrong...
Graham R Seach of Pacific Database Pty Limited was able to provide me with a starting point. I actually stunbled onto this as is was browsing his various free code for Access.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.