TADOTable raise Error code 3052 while post

From: Xie Bingpeng (xbp_at_teabird.com.cn)
Date: 04/29/04


Date: Thu, 29 Apr 2004 14:21:13 +0800

hi all:
   Delphi7, win2k
   I using following code for test:

AdoTable1 has 12000 records.

   AdoTable1.First;
   while not AdoTable1.eof do
   begin
     AdoTable1.Edit;
     AdoTable1.Fields[2].AsFloat:=0;
     AdoTable1.Post;
     AdoTable1.Next;
   end;
when update to 9000 records, AdoTable1.Post will raise error:
number of rows with pending changes exceeded the limit(when
Locktype=ltBatchOptimistic)
or
error 3052 (when Locktype=ltOptimistic)

does access has limit?
how to avoid this error?

thanks