ALTER USER

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RobUCSD - 16 May 2007 15:31 GMT

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

Reply to this Message

'69 Camaro - 16 May 2007 16:27 GMT

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.

Reply to this Message