Remote Security Administration

  • Thread starter Thread starter Dan
  • Start date Start date
D

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?
 
The problem arrises because the SystemDB is
a property of the DBEngine, not the workspace.
Click to expand...

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
 
Back
Top