Help with Access Security - adding user 1

[AKMonkeyboy]

I set up security for my database so long ago that the details are fuzzy. I went today to add a new user via Tools>Security>User and Group Accounts and the "New..." button is not enabled.

Any thoughts as to what I'm missing? My user is set up as an Administator - what else is there?

Monkey

Give a man a fish, and you feed him for a day.
Teach a man to fish, and you feed
him for life.
Send a man to Tek-Tips and the poor sap can find out how to fish on his own, and learn more by doing it.

 

[JerryKlmns]

I don 't know about your problem but until you find it out

open a connection(Cnn) to your database and execute the following lines

'create the user
Cnn.Execute "CREATE USER TheUserID HisPassword ThePID"

'add him to Users group [always]
Cnn.Execute "ADD USER TheUserID TO Users"

'add him to a group
Cnn.Execute "ADD USER TheUserID TO HisGroup"

BTW I did like your signature very much I 'll give you a star for that

 

[IanAble]

If the mdw (workgroup information) file was created in a previous version of Access (than you're currently using) you'll get problems with creating groups and users. Try recreating the mdw file and check that you are a member of the default Admins group.

 

[AKMonkeyboy]

Thanks all - I was thinking I may have to re-create the security file, but didn't want to have to do that.

Jerry: I'll have to check my code, but I think I use what you supplied to add users - had the flu yesterday and just don't feel like pouring over code right now - thanks for the star!

Monkey

Give a man a fish, and you feed him for a day.
Teach a man to fish, and you feed
him for life.
Send a man to Tek-Tips and the poor sap can find out how to fish on his own, and learn more by doing it.