Form/Switchboard Security

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

Guest

Our company has all of our information in one database which I have designed
by trial and error. Included in this information are all the employees'
info., salary, etc. I would like to require a password for just these forms
or switchboard menu items. I am using Access 2000. Iwould greatly
appreciate any tid bits you could provide!
 
Nooooo. That is not secure and too easy to get around. You need to set up
the built-in user-level security that comes with Access. This is by no
means an easy task. You will want to read all the various FAQs and
whitepages out there several times. You will also want to work on a copy of
your database.

You need to take this one step further and lock everyone out of the tables!
Otherwise, they could simply open the table and see the data. All objects
(forms and reports) will need to be based on queries that are built with
"run with owner permission" turned on.

You will then have to only let people who should see the data get into the
forms and reports where the data is displayed.

Do some searches and read every article on security that you find here in
the newsgroups before you proceed.

Good luck.

Rick B
 
Back
Top