I have tried this and I am now at this stage:
- Have my users added to Sql Admin table
- I Get User from user computer and verify it it exists in SQl admin table. If it does application continue if not message appears "Not existing user" and Access closes.
Connection to SQL server is done through Connection string that I set in code together with password and user name for the whole group that I created in Sql server.
But now I am asked to provide with option to reset or change in some way the password that I submit to Connection string because I am here temporary and they want to be sure that password get changed.
Everything looks great and they are satisfied, but now I don't know how could I do this, since password and user name is hard-coded in connection string, that looks something like:
Public Const strOLEDBConnect = "Provider=Microsoft.Access.OLEDB.10.0;Data Provider=SQLOLEDB;Data Source=MyServerName;Initial Catalog=MyDataBase;User ID=GroupUserName;Password=GroupPassword"
Thanks a lot