ALTER USER

[Guest]

Does anyone have an example of how to use the ALTER USER statement in code? I
want to use it to allow users to change their passwords when I deploy the
app. Currently I have everybody with the password "new", and at initial log
on I want to promt them to change their password.

I'm using user level security, developing in Access 2007 and deploying the
app as a 2003 mde over a citrix farm with the back end on a server.

Thanks in advance, Rob

 

['69 Camaro]

Hi, Rob.

Does anyone have an example of how to use the ALTER USER statement in
code?

Try:

ALTER USER UserName PASSWORD NewPswd OldPswd;

I'm using user level security, developing in Access 2007 and deploying the
app as a 2003 mde

This is not advised. Develop on the same version as your users, or you will
spend inordinate amounts of time troubleshooting why things don't work on
your users' workstations when they work perfectly fine for you, especially
when the version you are using hasn't yet been issued the first service
pack.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.