[AccessD] Access Security

Here is another method called vPPC
– Virtual Password Protected Connection

It has been developed for Access 2007 accdb's, where user security methods
have been dropped, to rely just on a stronger password method.
There is an pdf article describing it and sample mdb's for Access 2003 
and 2007
I haven't field tested it though. It uses a mid-tier accdb or mdb that 
only contains
linked tables and queries with password protection.
It is from a UK firm Premier Data Technologies.

http://www.pdtltd.co.uk/pdtl/technicalresources.htm

Barbara Ryan wrote:

>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
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada