[AccessD] Memo/Attachment fields

IIRC, I tried to prevent excessive locking by moving several memo fields to
a one-to-one related table.  It didn't make a difference.  I tried several
scenarios and multiple records in the main table still locked up while
editing a single memo field in the related table.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Monday, December 06, 2010 2:41 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Memo/Attachment fields

The idea of storing memo fields in separate tables is to  help prevent
record/page locking 
problems in a multi-user environment.

Based on this statement from Microsoft:

"By default, each field in a relational database contains only one piece of
data. For example, 
if an address field contained more than one address, finding addresses would
be difficult, if 
not impossible. So at first glance, attachments seem to break the rules of
database design 
because you can attach more than one file - one piece of data - to a field.
However, 
attachments do not break any design rules, because as you attach files to a
record, Office 
Access 2007 creates one or more system tables and uses those tables behind
the scenes to 
normalize your data. You cannot view or work with those tables.",

it appreas that the attachments are in fact stored in separate tables. I
really don't see any 
other way they could be doing it.   If that is so, the recommendation
doesn't apply.

-- 
Stuart


-- 
Stuart

On 6 Dec 2010 at 8:48, Mark Simms wrote:

> I saw a recommendation to always place memo fields into separate
> tables linked to the main table by an FK. Does anyone employee this
> technique ? I wonder if the same applies to attachment fields (AC2007)
> as well ?
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



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