Re: Registering New Users in VBA
if a user doesn't have adimn privileges to rights database (ie the mdw files) he won't be able to change other users. They can change their own passwords etc, but not other peoples.
You can't have it both ways. Any user who can manage the mdw file for other users has to be "god" if you like, and can change anything for anyone.
I think that is right. You might be able to manipulate the rights database programmatically with DAO, and assign temporary privileges in code - but I am not sure how far you can go, and it's probably more work than you want.
O'Reilly do a very thorough book on DAO with a lot of this stuff in it.
DAO Object Model (Helen Feddema). Basically there are Users and Groups collections of objects, that store all this stuff.
Gemma was my dog
if a poster helps you, please click the scales at the top right of this posting, or use the thanks button alongside.