Change Password MS Access Database
-
Does anyone know how to allow a user to change the password in an MS Access database? My connection string (at least the path and password) is set programatically, read in from an encrypted file when the application loads, but I need to enable to user to change both the path and password for the database if necessary. Selecting the path is easy enough, but I'm not sure how to reset the password. Any help would be appreciated. Thanks.
-
Does anyone know how to allow a user to change the password in an MS Access database? My connection string (at least the path and password) is set programatically, read in from an encrypted file when the application loads, but I need to enable to user to change both the path and password for the database if necessary. Selecting the path is easy enough, but I'm not sure how to reset the password. Any help would be appreciated. Thanks.
not sure about this, but its probably not a good idea to use direct sql/access passwords for logging into a database.
a better approach might be to have a default login with public access. and then have a table with user names and password combination.
at the login screen, a query (using the default login) is done of that user table, and if a successful match is found then they are allowed to enter the application (with all queryies being run with the default access login).
changeing passwords would then be fairly simple, it would only be change to the table that holds all your users.
as far as tracking changes to rows, a unique session id can be created when a user logs in, and this ID can be used to track changes of data (like if someone decides to save somethign in the data base, the session id would be inserted with the row, and that session id would like to a user name)
not sure about best practices, but this approach seems resonable.
not sure about concurrency issues with access when it comes to using a single username and password to log into a database for multiple users....