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