[AccessD] Database Needs Password Protection

Rocky,

 We'll access of everything through a query at least.  And yes, it takes a
serious amount of work.  

 I did it once and swore I'd never do it again.  Access/JET security is so
crackable it's just not worth it.

 But it is doable...

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Monday, April 26, 2010 1:58 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Database Needs Password Protection

Sounds like some serious rewrite of the app - lots of direct access to
tables through DAO.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Monday, April 26, 2010 10:38 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Database Needs Password Protection

Rocky,

  Yes, you can do that, but it's a lot of work.  What you need to do is
setup one user (or group) with full access to the tables and take all
ownership of everything. 

<<snip>>