[AccessD] Redesign the problem to fit the solution

Jim,

Well, I am at a standstill because I do not know how to 
programmatically test the locking issue.  Through the 
interface the record is locked, but I can still edit it with 
a recordset.  I was going to use the recordset to test for, 
find and log the locks but the recordset doesn't see the locks.

I am going to try using an ADO recordset to test the locks 
and see if that can see them.

John W. Colby
www.ColbyConsulting.com


Jim Dettman wrote:
> JC,
> 
> <<Where do you find this information about memos?  My reading 
> (and it was many months ago so I can't lay my hands on it 
> either) indicated that it a memo page can in fact hold 
> pieces of memos in different records.>>
> 
>   You are correct and I'm all wet.  From the JET 2.0 understanding JET
> locking white paper:
> 
> "An exception to this is when a long value page contains data from more then
> one row of data at which point Jet will release the read lock on that page.
> An example of this would be when several rows of memo data are placed on one
> long value page."
> 
>   Clearly indicating that a LVP can contain memo data from more then one
> record.
> 
>   I also went back and looked at the 3.5 whitepaper, which indicates that
> read locks on LVP's are not placed if the data doesn't span more then a
> page.
> 
>   Apologies for the confusion.
> 
> Jim.