I am having a problem trying to use a secured access vers. 2 database.  I have created a
system.mda
and even renamed it to system.mdw, as per the documentation.
I can select the system database and open the database mrp_vb.mda in access and use the security
functions
without problems, however when I try to use the following code in VB4,  I always get the error
code 3028
"Can't find the system.mda or it is opened by another user"

Any help with this problem would be gratefully received..

____________________________________________________________________________

Private Sub Form_Load()

    Dim suser As String
    Dim spw As String
    Dim specialWS As Workspace
    Dim sNewUser As String
    Dim sNewPw As String

    sNewUser = "Bob"
    sNewPw = "letmein"
    suser = DBEngine.Workspaces(0).UserName
    DBEngine.IniPath = "C:\windows\pmtest.ini"
    Set specialWS = DBEngine.CreateWorkspace("special", suser, spw)
   Set Newworkspace = DBEngine.CreateWorkspace("Newworkspace", sNewUser, sNewPw) **** Err 3028
End Sub

___________________________________________________________________________

C:\windows\pmtest.ini

[options]
SystemDB=C:\applicat\pmtest\system.mdw

[pmtest]
LoadSystemDB=Yes

____________________________________________________________________________

FYI, the .IniPath property is not used to indicate the system
database with 32-bit VB4. You need to set the SystemDB property
of the DBEngine object.

HTH,

Joe

Never underestimate the power of a WAG.