[AccessD] Access Security

Hi Barb,

This assumes you are trying to protect the tables, not the data.

1) Take a look at Gary Robinson's web site:
	http://www.vb123.com/toolshed/04_docs/accessdb_op_security.htm
	I do this at two customer sites and it works well.

2) Perhaps you could upsize the BE to SQL Server 2005 Express.  It's free.  
   You can relink the FE to the tables in the BE, very similar to Access 
   Table links.  Now regular users can't open the BE to modify tables.


Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Barbara Ryan
Sent: Tuesday, May 29, 2007 1: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