Access 97: Allow Non-Administrator to Add Users/Change Passwords With Form

[Larry R Harrison Jr]

I have an Access 97 secured database which the client will need to add users
etc to it periodically for certain permissions.

I have already secured it and now how to handle these permissions myself.
The idea is to make HER able to do it, yet for her not to be the full-blown
administrator of the database. She should be able to add a user, assign the
user to a given security group which already exists (she CAN'T create these
groups or change THEIR permissions), and change their passwords.

I have been successful at using DAO to create a form for this very purpose
in Access 2000 & XP databases (link to how:
http://www.dbases.net/knowledge_base/security_form_for_changing_passwords.html)
but not sure if this can be done in Access 97 as it does not have DAO.

Tips?

LRH

 

[Peter Russell]

I have been successful at using DAO to create a form for this very
purpose
in Access 2000 & XP databases (link to how:
http://www.dbases.net/knowledge_base/security_form_for_changing_password
s.html)
but not sure if this can be done in Access 97 as it does not have DAO.

Access97 does have DAO. What it doesn't have is ADO.

Peter Russell

 

[Larry R Harrison Jr]

Silly me! How could I miss that!

I was able to import that form (which I made) into the 97 database easily
(after converting it to 97); only the thingie showing the path to the tables
doesn't work, all else works fine.

Silly me!

LRH

 

[kaushik1102]

Hi,

I am facing a similar problem as ur's.Unfortunately I do'nt have
permission for the page [http://tinyurl.com/4po9p].

Can you pls send me a copy of the same?my email is
(e-mail address removed)

Regards