Access Built in Security

[Joe Williams]

I am using AccessXp with classic split DB design with built in Access
Security.

I find that using the built in security is a pain. for instance, in order to
add a user you have to add thier name, enter the PIN, assign them to groups.
Then you have to log out, log back in as the new user, and go back to the
same spot to change thier password from blank to something real. Is there a
better way to do this that I am missing?

Also, Can I attach to the mdw file from a third party mdb and make changes
to the users and permissions from that database?

Thanks

Joe

 

['69 Camaro]

Hi, Joe.

I find that using the built in security is a pain. for instance, in order to
add a user you have to add thier name, enter the PIN, assign them to groups.
Then you have to log out, log back in as the new user, and go back to the
same spot to change thier password from blank to something real. Is there a
better way to do this that I am missing?

Most people find that using the user-interface is the easiest way to create
users and set their permissions. The only other way to do the things you
ask for is with VBA code. You can see the sample code to do all of these
things in the Security FAQ on this Web page:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

Also, Can I attach to the mdw file from a third party mdb and make changes
to the users and permissions from that database?

The *.MDW file is a workgroup information file. One can join any workgroup
file that one has a UserID and password for. One can then open any database
and make changes to the users of that workgroup and their permissions,
provided the user logged in as has the appropriate permissions to administer
the database, such as a member of the Admins group. These settings will
only apply to the workgroup joined to prior to opening the Access database
file.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)