Code Username and Password

[aw23]

I have a workgroup file where each user has a username and password. The way it works now, everytime there is a new user I have to manually add them. How can I add a username and password and maybe delete too through code?

Thanks

 

[peachmelba]

AW23

Try using DBEngine.Workspaces(0).Users()

This will then let you add, change or set the password.

Regs

Peachmelba

 

[aw23]

Thanks but I really don't know anything about this. Can you explain it a little more please?
Thanks

 

[aw23]

Can anyone help me out with this please?

Thanks

 

[aw23]

Is there any way to code this?

Thanks

 

[SiberBob]

I haven't gotten into this part of App Dev yet, but I found some help on it in the Microsoft Bisual Basic help by searching the Help Index for DBEngine and then look at:

Workspaces collection
CreateWorkspace Method

as those specific topics seem to be related to your need...

Bob

 

[MoLaker]

Take a look at this thread

thread181-927394

There may be enough code there you can massage into what you need. If not, I've got a module with most of the commonly needed functions. Unfortunately it is on another system that is down right now. I can post later if you still need it.