Users setting own password

[sfinlay]

Hi

I'm currently designing a small database which will be distributed to users most probably using the access2007 runtime. I would like to be able to ship the database with a default username and password. Is this possible in acces 2007 ?
If it is possible, how would I go about enabling individual users to change the default username/password and set up a username/password of their choice ?

 

[ianward]

I did use a change password form that uses access security, see the link below to sample database, BEWARE if this is used on a non secured database, you could change the default access password, and unexpectedly lock yourself out.

It is simple to use just drop in the form and module and away you go! (Works in Access 2003) dont know about 2007.


http://www.access-programmers.co.uk/forums/showthread.php?t=111547

Regards

Ian

 

[sfinlay]

Thanks Ianward but it looks like this uses user lever access/groups which apparently isn't supported in access 2007

 

[David Anderson]

Thanks Ianward but it looks like this uses user lever access/groups which apparently isn't supported in access 2007

The User-Level Security feature, as used in Access 2003, IS implemented in Access 2007 - but only if you save your database as an mdb, rather than an accdb.

For more info,
http://office.microsoft.com/en-us/access/HA101662271033.aspx

David