[AccessD] Access Security

Thanks for all the suggestions --- I will check them out...........Barb

----- Original Message ----- 
From: "MartyConnelly" <martyconnelly at shaw.ca>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Tuesday, May 29, 2007 4:51 PM
Subject: Re: [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

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