Externally updating workgroups

  • Thread starter Thread starter Gareth
  • Start date Start date
G

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.
 
Maybe if you use ADOX, you could open a Catalog referring to a specific .mdw
file and manipulate users and groups accounts.
 
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
 
-----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.
.
Click to expand...


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