[AccessD] Memo/Attachment fields

LOL!!  Repeat!!

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:59 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Memo/Attachment fields

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

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