You use User objects to establish and enforce access permissions for the Document objects that represent databases, tables, and queries. Also, if you know the properties of a specific User object, you can create a new Workspace object that has the same access permissions as the User object.
You can append an existing User object to the Users collection of a Group object to give a user account the access permissions for that Group object. Alternatively, you can append the Group object to the Groups collection in a User object to establish membership of the user account in that group. If you use a Users or Groups collection other than the one to which you just appended an object, you may need to use the Refresh method.
With the properties of a User object, you can:
|?||Use the Name property to return the name of an existing user. You can't return the PID and Password properties of an existing User object.|
|?||Use the Name, PID, and Password properties of a newly created, unappended User object to establish the identity of that User object. If you don't set the Password property, it's set to a zero-length string ("").|
The Microsoft Jet database engine predefines two User objects named Admin and Guest. The user Admin is a member of both of the Group objects named Admins and Users; the user Guest is a member only of the Group object named Guests.
To create a new User object, use the CreateUser method.
To refer to a User object in a collection by its ordinal number or by its Name property setting, use any of the following syntax forms:
[workspace | group].Users(0)
[workspace | group].Users("name")
[workspace | group].Users![name]