[AccessD] The Famous Bound/Unbound Debate

Stuart McLachlan stuart at lexacorp.com.pg
Mon Sep 13 16:03:20 CDT 2010


But, but, but.....

I commonly use the second method in a bound sub-form.   Does than make mean I'm not a 
bounder after all?

D*mn, all this time, I thought I was a died-in-the-wool bounder.

-- 
Stuart

On 13 Sep 2010 at 14:42, Drew Wutka wrote:

> JC just brought up his 'call center' application, and a while back, we
> had a discussion about one element of that application.
> 
> It was in a 'memo' field.  Let's say we had to track calls coming in
> to a support center.  We'd have fields for caller, tech, date, time,
> issue, categories, etc.  And a memo field for details not put into
> more specific fields.
> 
> In a bound method, that memo field would be just that, one field, in a
> table.  So as notes are 'added' to a ticket, you are modifying one
> field, in one record.
> 
> In an unbound method, that memo field would be a separate table, with
> an ID field linking back to the original table.  Each entry would be
> timestamped (and stamped with the creator of the record).  You
> wouldn't edit a 'comment', simply add a new entry.
> 
> There are pros and cons to both methods.
> 
> Drew
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
> Sent: Monday, September 13, 2010 2:03 PM To: Access Developers
> discussion and problem solving Subject: [AccessD] The Famous
> Bound/Unbound Debate
> 
> All,
> 
> Compared to most of you, I am a relative newcomer to the world of
> Access.
> 
> Over the past few months, I have noticed a number of references to the
> Bound/Unbound debate.  It sounds like this was a really hotly
> contested issue at one time and that now people almost joke about it.
> 
> For us newcomers, it would be nice if someone could explain this issue
> at a high level and perhaps spell out the major pros and cons of each
> side of the debate.
> 
> It is not my intent to start a Web-war, I would just like to better
> understand what is going on here.
> 
> Thanks,
> Brad  
> 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.
> 
> 
> -- 
> 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