Trying to make a database fool - proof

[bmacrow]

Right, here is the situation. First of all my background, I am new to access,
having only used it for data input in the past, my background is television
production but i am currently in a temporary job for a finance company who
decided (somehow) my skills were best put to use creating a database for
their contracts.

Now the database is very nearly complete, i have implemented user level
security into it and even found a nice little form on the web that gave users
a form to alter their own passwords and admins a form to alter any password
(in case it gets lost). The end users of the databse are not computer
literate so everything needs to be handed to them on a plate but at the same
time i am only on a temporary contract so they need to do certain things one
i have left.

I am trying to find a way of creating a form on the database that will allow
admins to effectively administer users, by administer i mean i need a form
that will allow an end user admin to create a new user, alter existing users
permissions (my three basic permission levels are read only, full data edit
or administrator) and delete users.

I know its a big ask but does anyone know how to accomplish this, or would
be able to point me in the direction of a tutorial to get it done or even a
ready built solution, like the password changer i found.

Thanks in advance

Ben

 

[Keith Wilby]

Right, here is the situation. First of all my background, I am new to
access,
having only used it for data input in the past, my background is
television
production but i am currently in a temporary job for a finance company who
decided (somehow) my skills were best put to use creating a database for
their contracts.

Now the database is very nearly complete, i have implemented user level
security into it and even found a nice little form on the web that gave
users
a form to alter their own passwords and admins a form to alter any
password
(in case it gets lost). The end users of the databse are not computer
literate so everything needs to be handed to them on a plate but at the
same
time i am only on a temporary contract so they need to do certain things
one
i have left.

I am trying to find a way of creating a form on the database that will
allow
admins to effectively administer users, by administer i mean i need a form
that will allow an end user admin to create a new user, alter existing
users
permissions (my three basic permission levels are read only, full data
edit
or administrator) and delete users.

I know its a big ask but does anyone know how to accomplish this, or would
be able to point me in the direction of a tutorial to get it done or even
a
ready built solution, like the password changer i found.

At the end of the day, *someone* is going to have to have permissions to get
under the hood/bonnet to support the app so why not save yourself the bother
of reinventing the wheel and use the built-in dialog boxes from the db
window?

Just my 2p worth.

Keith.
www.keithwilby.com

 

[bmacrow]

hmmm yeah thats a really good point keith!

Ok, just another quick one then. My database startup options restrict menu
access to stop users from messing around, however this restricts the admins
from seeing the tools menu needed to access the secuiryt settings, now i know
you can bypass database startup options by holding shift, but is there some
vb code i can stick on a button that would launch the user and group accounts
dialogue?

cheers

Ben

 

[Keith Wilby]

hmmm yeah thats a really good point keith!

Ok, just another quick one then. My database startup options restrict menu
access to stop users from messing around, however this restricts the
admins
from seeing the tools menu needed to access the secuiryt settings, now i
know
you can bypass database startup options by holding shift, but is there
some
vb code i can stick on a button that would launch the user and group
accounts
dialogue?

This should do it:

DoCmd.RunCommand acCmdUserAndGroupAccounts

Regards,
Keith.
www.keithwilby.com

 

[bmacrow]

Ahha, perfect

Thanks very much for the help!

Cheers

Ben