[AccessD] Memo/Attachment fields

Stuart McLachlan stuart at lexacorp.com.pg
Mon Dec 6 14:58:59 CST 2010


I only said  "The idea ...is to help...".

I didn't say it actually worked  :-)

-- 
Stuart

On 6 Dec 2010 at 14:47, Dan Waters wrote:

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




More information about the AccessD mailing list