Enforce Pswd Chg Access/SQL using ODBC

D

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?
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Table Security in Access 2013 1
Access2010 redistribuible + runtime e ODBC issue 2
Manage ODBC 2
Sharing Access MDB or Accdb with client using older or newer version of Office 1
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
add password to circumvent mysql connector pop-up 3
Linking ODBC Tables for Multiple Users 7

Top