X
XcelSoft
I have an Access 2k db for which user seurity has been
enabled using a WorkGroup Information File. I am trying
to open the database in Visual Basic from another
maintenance db to set or turn off the "AllowBypassKey"
property of the secured database. I read the article
referred to me by Doug Steele but I'm still having a
problem. The following code is in the second db that
will basically open the secured database so I can then
change the AllowBypassKey property but it doesn't seem to
work because once you open the second DB it appears that
it's SystemDB is always pointed to the original
SYSTEM.MDW file in the common file folder. Seems like
the code below is not being acknowledged.
Dim dbs As Database, myWorkspace As Workspace
DBEngine.SystemDB = "c:\myfolder\secured.mdw"
Set myWorkspace = DBEngine.CreateWorkspace
("New", "userid", "password")
Set dbs = DBEngine.Workspaces("New").OpenDatabase
("c:\myfolder\mydatabase.mdb")
The Error "Not a valid account name or password" pops
up. I looked in the origninal system.mdw and the
secured.mdw and the user name is there.
Any ideas will be appreciated.
enabled using a WorkGroup Information File. I am trying
to open the database in Visual Basic from another
maintenance db to set or turn off the "AllowBypassKey"
property of the secured database. I read the article
referred to me by Doug Steele but I'm still having a
problem. The following code is in the second db that
will basically open the secured database so I can then
change the AllowBypassKey property but it doesn't seem to
work because once you open the second DB it appears that
it's SystemDB is always pointed to the original
SYSTEM.MDW file in the common file folder. Seems like
the code below is not being acknowledged.
Dim dbs As Database, myWorkspace As Workspace
DBEngine.SystemDB = "c:\myfolder\secured.mdw"
Set myWorkspace = DBEngine.CreateWorkspace
("New", "userid", "password")
Set dbs = DBEngine.Workspaces("New").OpenDatabase
("c:\myfolder\mydatabase.mdb")
The Error "Not a valid account name or password" pops
up. I looked in the origninal system.mdw and the
secured.mdw and the user name is there.
Any ideas will be appreciated.