[AccessD] Form corruption?

[Janet Erbach]

And I am doing that very test right now.  With interesting results, too -
inconsistent ones.

1)  When I run the test to draw objects on the form one right after
another, Access consistently chokes at object 1040.

2)  After I delete those 1040 objects and start drawing again, Access will
add another 1040 - a total of 2080 having been drawn to the form in all -
before it chokes.

3)  If I draw in 'batches' - add 500, delete 500, add 500 more - I can keep
going for a long time.  (This is with saving the form, closing it down, and
re-opening it after each batch.)  I got up to a total count 20,000 some
objects that had been drawn to the form over it's 'life time' before access
gave up.

4)  I started playing with drawing objects in different batch sizes.  I
just now ran a few batches of 500, then ran one of 2,000, then upped it to
5,000 .  Access choked  after drawing a total of 6120 objects.

So it seems that Access is inconsistent in it's response to how many
objects have been drawn, deleted, and re-drawn on the form over the course
of it's lifetime.  Which is the ammo I need to bring to my boss when I tell
him the whole form handling routine has to be re-written.

Janet





On Tue, Mar 3, 2015 at 6:38 PM, John W. Colby <jwcolby at gmail.com> wrote:

> It sounds like it's time for Janet to do a test!
>
> ;)
>
> John W. Colby
>
> On 3/3/2015 7:35 PM, Jim Dettman wrote:
>
>> The number given has always been 754,  but that has drifted upwards to
>> over 1,000 in later versions.   I posted all the counts a few years back.
>>
>> Jim
>>
>> Sent from my iPhone
>>
>>  On Mar 3, 2015, at 6:45 PM, Charlotte Foust <charlotte.foust at gmail.com>
>>> wrote:
>>>
>>> It used to be in the documentation, but I haven't looked it up recently
>>> because it became moot after they introduced tab controls.
>>>
>>> Charlotte
>>>
>>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>