When adding a new user under Access97, the following code always worked:
Now, since changing to XP, it errors out on the "Set NewUser" line. Anyone have a better way of adding users?Code:Dim NewUser As User
Dim NewWorkspace As Workspace
Set NewWorkspace = DBEngine.Workspaces(0)
Set NewUser = NewWorkspace.CreateUser(txtUserName, txtPID, txtPassword1)
NewWorkspace.Users.Append NewUser
NewWorkspace.Users.Refresh
