If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form/Switchboard Security
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! |
#2
|
|||
|
|||
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 "BMGSurvey" wrote in message ... 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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook 2000 Shared Calendar: How to stop the security prompts? | Mike Reed | Calendar | 2 | October 17th, 2004 11:42 PM |
Attachment Security Warning in Outlook 2002 | E Ortega | General Discussion | 0 | July 30th, 2004 06:38 PM |
I can't change the macro security level | Julie | General Discussions | 3 | May 6th, 2004 03:53 PM |
Prove that security package | Kelly and Leanne | Worksheet Functions | 0 | September 21st, 2003 06:24 AM |