Change Password with code

[Damien McBain]

My DB is secured with a workgroup file. All the forms are full screen so
there are no menus and users can't show the DB window.

Does anyone know where I can find some code to change the current user's
password? I've looked on Lebans, Allen Browne and, MVPS. Also googled a bit.

Damien

 

[Wayne Morgan]

It is part of the Workspaces object.

DbEngine.Workspaces(0).Users("UserName").NewPassword "OldPassword",
"NewPassword"

 

[Douglas J. Steele]

Wayne's given you the correct answer. You may want to check out the Access
Security FAQ for other useful code snippets.
http://support.microsoft.com/support/access/content/secfaq.asp