Setting Security on a Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I am creating a Database and want to set each user up with a unique Login ID
and Password, can you help?
Also once this has been done, when the User then logs in I need to set
restriction on what they see, sometimes it may be read only depending on who
is looking at the information.
Can someone point me in the right direction as to how I go about doing this???
I am Using Microsoft Access 2000.
Thanks for your help.
Paul
 
A good resource is Volume 2 of the "Securing Your Application" in the Access
200x" Developers Handbook" by Paul Litwin, etal. They have some good sample
code. I use their DAO procedures.
 
Earl,

Thanks for your response. I presume this handbook will step me through the
procedures needed to Set up users with Login ID's and passwords? and then
will show me how to limit restrictions on what they actually see when they
log in using there ID's and passwords?
thanks
Paul
 
Paul, I consider the Access Developer Handbook series to be the best Access
documentation available, starting about 10 years ago with Access 2.0. Their
Access 2000 may be out of print but I bet Amazon.com has it. The Access 2002
set (of 2 vols) is almost the same so you may want to get that instead in
case you upgrade later. They have yet to publish one for Access 2003.
 
Paul,
The Access Developers Handbook is an excellent resource for all kinds of
programming needs, including security. However, the real source of
information about setting up security is the Security FAQ from Microsoft.
There is a link to it on the Security page of my website.
 
Back
Top