[AccessD] Memo/Attachment fields

Darryl Collins Darryl.Collins at iag.com.au
Mon Dec 6 16:58:55 CST 2010


_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________



Hi Mark,

I have personally experienced corruption issues with Memo fields in the 'main' table.  Since then I always put them into a separate table and link on the key.  That seems to work well. I have notice no performace hit.  Actually it might even speed things up if you are playing with the main table RS and don't need to reference the data in the memo field.

Just my thoughts.

cheers
Darryl
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Tuesday, 7 December 2010 12:48 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Memo/Attachment fields

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
_______________________________________________________________________________________

The information transmitted in this message and its attachments (if any) is intended 
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review, 
retransmission, 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.

If you have received this in error, please contact the sender and delete this e-mail 
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute 
the information contained in this e-mail and any attached files, with the permission 
of the sender.

This message has been scanned for viruses.
_______________________________________________________________________________________




More information about the AccessD mailing list