Externally updating workgroups

[Gareth]

I know that you can programatically update/amend a
workgroup which you are logged on with. But can you
update/amend a workgroup which you are not?
I will be logged into a different mdb & mdw from which i
want to be able to add/remove users to different
workgroups so i can centrally administer a set of mdw's
without having to separately log on to them and then
update.

Can this be done? any help or pointers would be great.

 

[JR]

Maybe if you use ADOX, you could open a Catalog referring to a specific .mdw
file and manipulate users and groups accounts.

 

[TC]

I don't have Access here to check, but something like this should do the
trick.

Dim dbe As PrivDBEngine, ws as workspace
Set dbe = New PrivDBEngine
With dbe
' open a new session of Jet, using the relevant workgroup file.
.SystemDB = "C:\blah.mdw"
.DefaultUser = "Tom"
.DefaultPassword = "secret"
' access the workspace.
set ws = .workspaces(0)
' now you can use workspace methods (eg.
' ws.CreateUser) to update the workgroup file.
...
set ws = nothing
End With
set dbe = nothing

User Tom (or whoever) would need sufficient priviliges to create new users &
so on.

HTH,
TC

 

[Guest]

-----Original Message-----
I know that you can programatically update/amend a
workgroup which you are logged on with. But can you
update/amend a workgroup which you are not?
I will be logged into a different mdb & mdw from which i
want to be able to add/remove users to different
workgroups so i can centrally administer a set of mdw's
without having to separately log on to them and then
update.

Can this be done? any help or pointers would be great.
.

you should make one workgroup file with a number of
different groups to incorporate all permissions