[AccessD] Redesign the problem to fit the solution

Exactly Max.  Unbound methods are NOT meant to replace bound
capabilities.  They are meant to do things that bound methods can't, or
not as easily.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Thursday, May 29, 2008 2:40 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Redesign the problem to fit the solution

John,
Not wishing to add fuel to any embers that may be smoldering, but all of
this is just re-inventing the wheel.  Access does all of this and lots
more
in a Bound Form.  As I understood it you just had a problem with locking
spanned unconnected records.  I think that between what Gustav and
others
have said you have a solution - keep the bound form with all its
*features*
- extract the memo field to a separate table.  Perform a pseudo lock on
that
if it does not lock to your satisfaction.

BTW, I am assuming in all this that you have selected "Edited Record" as
the
"Default record option" in the database options window under the
"Advanced"
Tab.

Max

 


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 Business Sensitive 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.