[AccessD] Access Security

The best method would be to use Access User Level security.  I may seem complex at first, but it is very functional.  Users should have the access they need on the tables, and that's it.  In theory, there is no real way to prevent a user that has access to the data from opening the table.  No matter what you do to the front or backend, if they have access, they can link to the BE, and open the tables directly.  With User level security, they would be limited to what you have given them (read, update, insert, delete).
 
Drew

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of Barbara Ryan
Sent: Tue 5/29/2007 1:33 PM
To: Access List
Subject: [AccessD] Access Security



What is the best method to lock users out of the BE tables and (linked) FE tables in an existing Access 2003 application?  The client wants users to be able to create ad hoc queries, forms and reports in the FE, so using an MDE is not an option.  (They do not use the separate "ad hoc" database that I provided them :-(  Only "super" users should have the capability to access data tables directly

I found some 3-year-old security info in the archives, but was wondering if opinions have changed since then. 

Thanks,
Barb Ryan

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/> 



The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI BusinessSensitve material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.