Add Users - Workgroup

[skennell]

Is it possible to add new users through VBA for a user (or group) who is not a member of the Admins group? I would like for this user to add/delete other users, but not have design permissions. I tried giving this user Administer permissions for the database, but I believe it only allows the user to change passwords. Thanks in advance.

[jackd]

skennell

I haven't worked with Security. However, I have found a few references which may help you with the question. Seems to me that an Admin user can users and permission, not a regular user. But that's justmy read of it.

There is a write up, along with vba examples, on adding users, adding permissions, adding groups etc in Access Developers Handbook by Ken Getz.

Here is a link I found that has lots of detail. As I said I'm not familiar with security or this link, but thought I'd pass it on.
http://www.grahamwideman.com/gw/tech/access/accesssec/index.htm

[skennell]

Thanks for the link. I will check it out. I have researched and utilized the write up by Ken Getz, and it has definitely helped me. Again, I appreciate your help.