Securing an Access Database

[skennell]

I am a noobie regarding Security issues. I need to distribute a database that will have one member in the Admins group and one member in a Users group with limited permissions.

I would like to be able to set up the accounts through a form after the database is open. I am sure I can do this through VBA code, but I am looking for some sample code or direction on the best way to approach this. Thanks in advance.

[OBP]

Why would you want to set up the accounts using a form?
Would that not invalidate the Security, as anybody could then use the form to join the Admins group?

[skennell]

So I should set them up through the User and Group accounts first, and then distribute the application? I was thinking they could change their passwords via form. Thanks again.

[OBP]

skennell, yes set them up first.
It should be possible to set up a form to just allow password changing.
Let me know if you want me to research it?

[skennell]

Thanks, I can do the research. I hate to sound like a noobie, but so be it!

[Cosmos75]

Be sure to read the Microsoft Access Security FAQ (http://support.microsoft.com/default.aspx?scid=%2Fsupport%2FAccess%2FContent%2FSECFAQ.asp).