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


Reply With Quote