[AccessD] Access XP forms bound to ADO recordsets

>I am ashamed to even raise my hand given that I was the one that asked if
> this was possible and prompted your working on this,
No problem, John, you "switched on" an interesting topic and an advanced 
open source project, which I do think will bring useful for real work 
result - in fact one such result is here already (see below)

> Do we know what allowed him to get past the 2010 barrier,
>  what the barrier is?
Here is a lucky environment where the test passed 2700 cycles with 2700 
defined as a max value i.e. it passed all the cycles OK.
<+
Windows XP Pro SP2,
Microsoft Access 2003 SP2,
all other service packs are the latest,
ADO 2.8.
Hardware is IBM ThinkCentre with dual P4 3.2 GHz, 512 mb ram.
->

<+
Backend:       MS Access
Binding:       ADODB
Cycles to pass: 2700
Cycles passed: 2700
Total errors: 0
Forms opened:  13500
Start time:    3/21/2006 4:04:06 PM
End time:      3/21/2006 5:19:49 PM

Object statistics:
ClassName = CTestForm, Created = 6, Disposed = 6
ClassName = CFormDataset, Created = 97337, Disposed = 97337
->

I will publish/post with pleasure the name of this lucky man/early 
adopter/great helping hand when I will get his permission.

And I think the first three developers (or more?) will do deserve honorable 
mention on AccessD web-site in the next issue of Database Advisors Gazette - 
what about that?

Anybody courageous soul to first reach 10000 cycles working OK - just put 
your PC crunching this test  over week end if you have the "lucky 
environment". The memory consumption isn't high - when I get it stopped on 
~2010 cycle MS Access has only 32MB in use - almost nothing for nowadays 
systems....

This is a really hardcore case and if solved it will be useful for all I 
think because it will define the safest current MS Access 2003 environment.

It would be interesting to know how and why it comes that exactly around 
2010 cycle the test breaks on MS Access 2003 SP1 but the answer can be 
obtained probably from MS Access development team only and the hopes to get 
this answer are currently low because they are busy working on MS Access 12 
Beta 2 release...

Shamil

----- Original Message ----- 
From: "John Colby" <jwcolby at ColbyConsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Wednesday, March 22, 2006 7:32 PM
Subject: Re: [AccessD] Access XP forms bound to ADO recordsets


>I am ashamed to even raise my hand given that I was the one that asked if
> this was possible and prompted your working on this, and then haven't even
> had time to test.  But...
>
> Do we know what allowed him to get past the 2010 barrier, what the barrier
> is?
>
> And I will be testing this as I have a use for it in real life.
>
> John W. Colby
> www.ColbyConsulting.com
>

<<< tail skipped >>>