Establish database security

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

Guest

Hi everyone!
My boss want me to set the database security . This Access db is used by
different people in the office . So i set all the Users login and
permissions. The problem is that only work on the computer that i've used to
set up the security. If i go on another computer in the office, Access
doesn't ask that user to logon so he still can have access to every object of
the database.
How can i fix that?
thanks for your advices
regards,
 
boubou said:
Hi everyone!
My boss want me to set the database security . This Access db is used
by different people in the office . So i set all the Users login and
permissions. The problem is that only work on the computer that i've
used to set up the security. If i go on another computer in the
office, Access doesn't ask that user to logon so he still can have
access to every object of the database.
How can i fix that?
thanks for your advices
regards,
Click to expand...

This sounds as though you just went to the security menu and started adding
groups/users and setting permissions.

There is much more to implementing security than that.

Start by undoing what you have done. Then download and study the security
FAQ
http://support.microsoft.com/?id=207793

Also read the Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you
understand security.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm
 
Back
Top