[AccessD] Transactions

jwcolby jwcolby at colbyconsulting.com
Thu Sep 6 10:24:56 CDT 2007


I'll bite, how do you do this in an MDB?

John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka
Sent: Thursday, September 06, 2007 11:05 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Transactions

Why not do it at the table level?  Denying Update and Delete, allowing
Insert.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Wednesday, September 05, 2007 10:45 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Transactions

I've developed this software and I totally agree with the accountant's
analysis, which reduces to: recorded transactions are history and cannot be
edited. All you are allowed to do is add an adjustment that refers to some
previous transaction and supplies a positive or negative number as the
adjustment.

My question is this: given a continuous form or datasheet presentation of
the data, how do I prevent editing of the existing rows while also allowing
new rows to be added? Is this as simple as the Allow Edits / Allow Deletes /
Allow Inserts properties on the property sheet? I've never experimented with
these, but suddenly I need to know. I need to prevent editing of any
existing transaction but allow addition of new transactions. Is this as
simple as those aforementioned flags on the properties sheet?

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


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




More information about the AccessD mailing list