[AccessD] Access Security

Barb,

One solution springs to mind.  Make the tables invisible.  Create one query
for each table, SELECT * FROM MyTblName.  Make each of these queries a
snapshot.  That prevents updating the data in the table, but the data can be
read as normal.

Having users creating adhoc forms is a recipe for disaster IMNSHO.  AdHoc
queries and reports are another matter.  They can be based on the read only
queries and voila.


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Barbara Ryan
Sent: Tuesday, May 29, 2007 2:34 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