is it possible to code change of password via vba

[Guest]

i use a2k...

when a user hits the Shift key while entering the password, he or she is
provided with a glimpse of the access object window, otherwise the user is
given a prompt to enter his designated username into a third party product's
password entry form -- after which the user is allowed to use the
switchboard.

i would like to grant certain users rights to change the Acess 2000
password. my goal is to prevent that user from entering the Shift key when
entering the A2K password. i know how to disable the Shift bypass but wonder
what to do when it comes to the user's being able to modify the A2K bypass
w/o that privilege. if there were some way i could grant only users having
certain usernames (known at the time when the user logs in via the 3rd
patry's second log in prompt), the wherewithall to change the A2K password
(perhaps via some vba code that could be used only by the user possessing a
'System' username i think that would be great. but is there any way that vba
has been deployed to change A2K passwords at all?

-ted

 

[Tim Ferguson]

i would like to grant certain users rights to change the Acess 2000
password.

Surely all users should be able to change their own passwords?

If you want to prevent some users from changing their own passwords, then
it should not be too hard to do. Assuming you are using user level
security, then you can create a group and check the user's membership of
it before opening the ChangePassword form.

I wondered from you post whether you are using a Office File Password --
but I hope not because it's barely worth it's weight in electrons so far
as security is concerned, particularly if you have told lots of people
what it is.

Hope that helps


Tim F