Need help for lock the row
Quote:
>> I have open the recordset (dbOpenDynaset) which contain one row only.
>> I found it will lock several rows after use Edit method. How can I lock
>> that row only??
>> Thanks a lot
>I assume you are using Access.
>Access uses page locking which locks 2k at a time. If your records are
>less than 1k then Access will lock more than one record.
>The only way out of it that I know of is to make sure that every record
>in your table is larger than 1k. Depending on the current size of your
>records, how many you have, available storage this is probably going
>overboard.
>Peter
Peter,
You said:
Quote:
> The only way out of it that I know of is to make sure that every record in your table is larger than 1k.
Why only 1K ?
If my record size is at bigger 1K in length, say 1k+a few bytes, will
my page locks then not go onto the next records ?
I'm new to this page vs record locking stuff.
Thanks.
