Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / January 2005

Tip: Looking for answers? Try searching our database.

Form/Switchboard Security

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BMGSurvey - 21 Jan 2005 20:39 GMT
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!
Rick B - 21 Jan 2005 20:57 GMT
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

> 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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.