[AccessD] Transactions

Ummm, I think we are talking past each other.  You CAN'T prevent someone
from getting to the database window.  It's just not possible.  Not if
they are allowed in the database.

'Hiding' the database window, and then disabling the Access Keys (which
includes F11), only requires that the user Clicks Window and then
UnHide.  Hiding the Access Window is also a work around, and is only
going to be viable if your application never needs to run a report
(since reports only show within the Access Window).  The work involved
in trying to maintain a process that prevents the user from getting to a
table is much more then simply setting up the appropriate security in
the tables from the get go.  In my example post, I went through and
blocked everything, but as long as Administrative rights are removed
from the database and tables, the data is safe.  Takes a few minutes at
most.  Locking down forms, reports, macros and queries is only if you
want to protect your design.

Another thing to keep in mind, is that if a future developer wants to
look at your system, by putting constraints in the tables themselves,
that future developer isn't going to have to dig through the interface
to find your data integrity rules.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Thursday, September 06, 2007 4:36 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Transactions

Drew,

Drew Wutka wrote:

> ... data integrity done only through the GUI is to easy to get
> around.

In 12 years as a full-time Access freelance developer, I have never had 
anyone get around it.  Yes, it can be got around.  Fair enough.  In
theory.

>  F11 or Window --> unhide will always let someone at the
> database window.

Agreed that it is unthinkable that a user should have access to the 
Database Window.  I never allow this.

Regards
Steve
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI BusinessSensitve material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.