Change SQL Server Password from Access

[cjman]

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?

 

[HiTechCoach]

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.

 

[cjman]

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.

 

[HiTechCoach]

So you need a way to programmically modify the password for a user in the SQL server Acess?

 

[cjman]

Sorry it took so long to reply. I'm in and out all day. Yes that is what I need to do.

 

[SQL_Hell]

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

 ALTER LOGIN Access WITH PASSWORD = 'apples'

 

[cjman]

Company Policy, Thanks