Enforce Pswd Chg Access/SQL using ODBC

[dmoody1]

I have an MS Access Application using ODBC to connect to a SQL. I want to
enforce password rules on the SQL. User must change password on first login
and require a change every 30 days. On first attempt to connect to SQL
through ODBC and Access, I get an error that can not connect due to password
needing to be changed. What do I need to change in order to allow this to
happen?

 

[Arvin Meyer MVP]

Since the password functionality is in SQL-Server, I would ask this question
in a SQL-Server newsgroup for a definitive answer. Try:

microsoft.public.sqlserver.security