[AccessD] Access XP forms bound to ADO recordsets

Hi All,

Please to not rush to upgrade for MS Office/Access SP2 - as Gustav noted you 
may get your MS Excel attached worksheets unupdatable:

<<<
You cannot change, add, or delete data in tables that are linked to an Excel 
workbook in Office Access 2003 or in Access 2002
http://support.microsoft.com/kb/904953/
>>>

<<<
Description of Office 2003 Service Pack 2
http://support.microsoft.com/kb/887616
>>>

Shamil

----- Original Message ----- 
From: "Shamil Salakhetdinov" <shamil at users.mns.ru>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Wednesday, March 22, 2006 9:45 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,
> 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

<<< taile skipped >>>