Using Workgroup information

[Guest]

I'm creating a database for a number of users. Each user will have a login
in the Access security file. However I also need to store details of users in
a table. I don't want creation of new users to be a too step process ie.
create the user using security then enter the name in a table. I'd like to be
able to use VBA to create the user in the security file and then add it to
the table and display a form to enter the rest of the details. My problem is
reading and writing to the workgroup file using VBA. Can anybody help?

Thanks

Alan

 

[TC]

Use the "users" collection of the "workspace" object:

dim u as user
for each u in dbengine(0).users
debug.print u.name
next

You can examine that collection to find any users whose names do not
appear in the table.

HTH,
TC

 

[Guest]

Thanks TC this is exactly what I needed to know.

Cookie