Remote Security Administration

[Dan]

I would like to add users and adjust permissions in a
different security database (.mdw) than the current one.
Is this possible with VB for Applications?

I have working code for performing these tasks in the
current security database. By the data access object
model it appears that any users I create would be in the
current system database not a remote one that I connect
to by opening a new workspace. The problem arrises
because the SystemDB is a property of the DBEngine, not
the workspace.

Any ideas?

 

[TC]

The problem arrises because the SystemDB is

a property of the DBEngine, not the workspace.

Well put! So you need a seperate dbengine object. Use the undocumented
PrivDBEngine object.

(untested - don't have Access on this PC)

dim dbe as privdbengine, ws as workspace
set dbe = new privdbengine
with dbe
.systemdb = ... ' voila!
.defaultuser = ... ' log-on username.
.defaultpassword = ... ' log-on password.
set ws = dbe.createworkspace()
' go to it!
end with
set dbe = nothing

HTH,
TC