Change SQL Server Password from Access

cjman

Registered User.
Local time
Today, 06:27
Joined
Mar 4, 2009
Messages
28
I have Access 2007 to SQL Server 2005 setup. I do not control security. I need to change a password through access to SQL Server 2005. I use SQL Server ODBC. The user name and password is all the comes up when opening DB. The error message says I need to change the password but there is no place to change it in the dialog box from SQL Server. I called my DBA. He told me that password change needs to be written in my front end. Whats the best way to do this?
 
Are you saying that the password in the SQL server has changed and you need to apply the change to the Access front?

If yes, then I would delete all the linked tabled and relink them to store the new password.
 
No, the Sql Authenication requires the password to change every 30 days. Everything was working fine until I had to change my password. There isn't a place to submit a new password when I login. I don't want to call the DBA every 30 days. I know that we will change to windows authenication in about 3 months. Until then I need a way to submit a new password.
 
So you need a way to programmically modify the password for a user in the SQL server Acess?
 
Sorry it took so long to reply. I'm in and out all day. Yes that is what I need to do.
 
Cant the DBA just remove the password expiry? it's a bit strange to have a password expiry for an application login.

If not then use ALTER LOGIN

Code:
 ALTER LOGIN Access WITH PASSWORD = 'apples'
 

Users who are viewing this thread

Back
Top Bottom