[AccessD] Access XP forms bound to ADO recordsets

Hi All,

I wanted to inform you about the current results:

The absolute for today result is achieved on Jim Moss system (MS Access 2003 
SP2):

 - 8729 cycles or
- 43644 opened forms (these are 130932 updates - I will add update counters 
later when inserts and deletes will be ready).

It breaks even with MS Access SP2 but the memory consumption on this 
breaking is normal - ~32MB.
Seems to be a Jet problem(see below) not MS Access? (It has to be rechecked)

This information and the fact that 43644 opened forms  is a way above of the 
quantity of forms, which are usually opened manually during one working day 
(43644/8/60/60 = ~1.52 opened form/second) lets to continue the testing and 
to add the new functionality.

Current statistics:
-----------------------

The one who fired(started I mean :)) this whole thread
=========================================

John Colby of course.

The best support/max test runs
========================

Author: Keith & Sandra (Keith)
------------------------------------------

They have Access SP1 system therefore ~2010 barrier isn't yet passed

The best inspirer  to run this test after he did run it
======================================

Gustav Brock - his appeal to run the test resulted in many new helpful test 
runs and we got passed ~2010 barrier


The first three positive results above ~2010 barrier
=======================================

1. Author: Jim Moss
----------------------------
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

2. Author Marty Connelly
------------------------------------
Backend:       MS Access
Binding:       ADODB
Cycles to pass: 2600
Cycles passed: 2600
Total errors: 0
Forms opened:  13000
Start time:    22/03/2006 10:00:18 AM
End time:      22/03/2006 2:21:28 PM

Object statistics:
ClassName = CTestForm, Created = 6, Disposed = 6
ClassName = CFormDataset, Created = 93583, Disposed = 93583

3. Author: Jim DeMarco
---------------------------------
Backend:       MS Access
Binding:       ADODB
Cycles to pass: 3000
Cycles passed: 3000
Total errors: 0
Forms opened:  15000
Start time:    3/22/2006 2:10:25 PM
End time:      3/22/2006 4:28:43 PM

Object statistics:
ClassName = CTestForm, Created = 6, Disposed = 6
ClassName = CFormDataset, Created = 107634, Disposed = 107634


Top result for today: 24-MAR-06 14:18 (GMT+3)
=====================================

Author: Jim Moss
-------------------------
Form_a_frmCrashTest.cmdCrashMe_Click(0): Err = 3011 - The Microsoft Jet
database engine could not find the object ''.  Make sure the object
exists and that you spell its name and the path name correctly.

Backend:       MS Access
Binding:       ADODB
Cycles to pass: 12500
Cycles passed: 8729
Total errors: 1
Forms opened:  43644
Start time:    3/22/2006 6:31:11 PM
End time:      3/23/2006 9:10:46 AM

Object statistics:
ClassName = CTestForm, Created = 6, Disposed = 6
ClassName = CFormDataset, Created = 313198, Disposed = 313198

Second top result for today
====================

Author: Rocky Smolin
------------------------------

ADODB Bound Forms Crash Test v.1.9.6 [23-MAR-06]

Form_a_frmCrashTest.cmdCrashMe_Click(0): Err = 3011 - The Microsoft Jet
database engine could not find the object ''. Make sure the object
exists and that you spell its name and the path name correctly.

Backend: MS Access
Binding: ADODB
Cycles to pass: 20000
Cycles passed: 6129
Total errors: 1
Forms opened: 30644
Start time: 3/23/2006 7:54:55 PM
End time: 3/23/2006 10:47:24 PM

Object statistics:
ClassName = CTestForm, Created = 6, Disposed = 6
ClassName = CFormDataset, Created = 220163, Disposed = 220163

----------

Thank you a lot for your support - it gives the assurance that the final 
successful result will be reached!

I plan to reorganize the web page(s) dedicated to this test and the names of 
all the supporters (with their permission) will be published on it. No 
e-mail addresses of course to prevent spam scripers to collect them.

Shamil

----- Original Message ----- 
From: "Shamil Salakhetdinov" <shamil at users.mns.ru>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, March 24, 2006 1:50 PM
Subject: Re: [AccessD] Access XP forms bound to ADO recordsets


> Hi All,
>
> New version (1.9.7) is available on
> http://smsconsulting.spb.ru/download/tests/a2dds.htm - this is just a
> maintenance/bug fix release - no new features.
>
> Shamil

<<< tail skipped >>>