Filling LIstBox with Access users names

[Stuart Jack via AccessMonster.com]

Hi

Does anyone know how to fill a listbox withthe login names of Database users
when Access security has been implemented, i want to be able to delete a user
from the system using the listbox to select the user to delete.

Many thanks

Stuart

 

[Michel Walsh]

You can cycle on the Users collection:


For Each x In DBEngine.Workspaces(0).Users
...
Next x


It would be a matter to append the user name to a list of values.



Hoping it may help,
Vanderghast, Access MVP

 

[Stuart Jack via AccessMonster.com]

Great, thanks very much.

Stuart

You can cycle on the Users collection:

For Each x In DBEngine.Workspaces(0).Users
...
Next x

It would be a matter to append the user name to a list of values.

Hoping it may help,
Vanderghast, Access MVP

Hi

[quoted text clipped - 7 lines]

Stuart