Using Access Security

J

Jason

Is there anyway to have a secure database where a person can't access the
passwords that are stored expect to change their own password?

Thnaks,
J.
 
R

Rick Brandt

Jason said:
Is there anyway to have a secure database where a person can't access
the passwords that are stored expect to change their own password?
Click to expand...

With standard user level security nobody has access to anyone's password but
their own. Administrators can clear a password or even assign a password,
but they cannot "see" a password once it is set.
 
J

Jason

How is this done in Access 97? I am just using a table at the moment. I have
different levels for different forms. If I use Access's built in security
how do I access it so that I can have certain people access/deny access to
various forms and reports.
Sorry for hte extra posting - just realised I should have asked in more
detail.

Thanks,
J.
 
J

John W. Vinson

How is this done in Access 97? I am just using a table at the moment. I have
different levels for different forms. If I use Access's built in security
how do I access it so that I can have certain people access/deny access to
various forms and reports.
Sorry for hte extra posting - just realised I should have asked in more
detail.
Click to expand...

Download the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Don't worry, it was not changed significantly between 97 and 2000.

Print this document out. READ IT, CAREFULLY.

Get a good night's sleep.

Reread the FAQ, even *more* carefully. Security is complex and it's easy to do
it wrong! You can make a database inconvenient for users and dead easy for
anyone knowledgable to break in; you can even lock it up so NOBODY, even you,
can get in.

Follow the checklist, step by step. It's straightforward if you follow the
steps and do it completely.
 
J

Jason

I've downloaded the mde file also: frmaccounts and frmmain generate errors:
with block witout set. can't get into the modules including froms so looks
like this file is of no use.
 
J

John W. Vinson

I've downloaded the mde file also: frmaccounts and frmmain generate errors:
with block witout set. can't get into the modules including froms so looks
like this file is of no use.
Click to expand...

I'm sorry, I have NO idea what you're talking about here.

The Security FAQ is a WORD document. You print it out and read it.
 
J

Jason

the doc makes reference to the mde file which I also download. My approach
is:
1. check if file exists then allowbypass keys are either true or false -
already done
2. Table in access that holds users - already done
3. Want to prevent access by either going file-1 (already done with 1) and
by linking from another database.
4. Hoping to usie Access Security to acheive this where table access is
handled by 1 and 2 and form and report access is by using the
internal/linked table in combination with Access Security (I.E. Name in
table links to name in Access Security so local mangers can just say user
has 0 restriction to level 9 restriction in the security form I've already
created).
 
Top