Using Workgroup information

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top