Work group file..

[access97to2000]

Hi,
Through Visual Basic 6.0 front end i have to add users to a system.mdw file to certain groups.
when i am trying to add it
Dim catDB As ADOX.Catalog


Set catDB = New ADOX.Catalog
With catDB
' Open Catalog object by using cnnDB.
.ActiveConnection = strConnect
' Create new user account.
.Users.Append strNewUser, strNewUserPwd
' Append new user account to default Users group.
.Groups("Users&quot.Users.Append strNewUser
.Groups("dataentry&quot.Users.Append strNewUser
End With

like this ... it is adding the user to the groups but when i try to log in with the same user - it says denied. But when i login as admin and go to the user and databse security settings, i can see the user being added to users, dataentry groups - what should i do ? Please help

 

[Junior1544]

I have a file that is all setup to do this stuff with access 2k if you'd like it... i'd be happy to send you a copy...

(i'm working on setting up a web server to host some of my files... to make it easier to distribute my code...)

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.