[AccessD] Access XP forms bound to ADO recordsets

Shamil Salakhetdinov shamil at users.mns.ru
Fri Mar 24 09:47:54 CST 2006


Thank you, Rocky,

I maybe prepare this night some corrections to try to catch the problem 
below with more log information written and then it should be possible to 
run the test on weekend - below are the two results (yours) and from Jim 
Moss - they are for different backends but break on the same 8729 cycle. 
Looks like a pattern. But I must say I think I see something like that the 
first time in my long programming experience. Very strange. Any 
explanations, anybody? (Please note that the quantity of created custom 
classes are different for these two cases - this is probably because the 
class instance for subform was created less times in the second case because 
creation of this class instance depends on data and the data "shuffling" and 
updating use random numbers generator....).

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

Form_a_frmCrashTest.cmdCrashMe_Click(0): Err = 2113 - The value you
entered isn't valid for this field.

Backend:       MS SQL
Binding:       ADODB
Cycles to pass: 10000
Cycles passed: 8729
Total errors: 1
Forms opened:  43644
Start time:    3/23/2006 4:32:18 PM
End time:      3/24/2006 6:13:39 AM

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


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

Form_a_frmCrashTest.cmdCrashMe_Click(0): Err = 2113 - The value you
entered isn't valid for this field.

Backend: MS Access
Binding: ADODB
Cycles to pass: 20000
Cycles passed: 8729
Total errors: 1
Forms opened: 43644
Start time: 3/23/2006 10:49:52 PM
End time: 3/24/2006 5:48:18 AM

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

Shamil

----- Original Message ----- 
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Friday, March 24, 2006 5:27 PM
Subject: Re: [AccessD] Access XP forms bound to ADO recordsets


> Shamil:
>
> Do you want us to run it again with this new version?
>
> Rocky
>
> Shamil Salakhetdinov wrote:
>> 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.
>>
>> Best regards,
>> Shamil
>> --
>> Web: http://smsconsulting.spb.ru/shamil_s
>>
>> ----- Original Message ----- 
>> From: "Shamil Salakhetdinov" <shamil at users.mns.ru>
>> To: "Access Developers discussion and problem solving"
>> <accessd at databaseadvisors.com>
>> Sent: Thursday, March 23, 2006 5:13 PM
>> Subject: Re: [AccessD] Access XP forms bound to ADO recordsets
>>
>>
>>
>>> Hi All,
>>>
>>> New version  (1.9.6) of the subject test released at
>>>
>>> http://smsconsulting.spb.ru/download/tests/a2dds.htm
>>>
>>> You can now use Customers form to manually add and deleted rows, which 
>>> are
>>> bound to disconnected ADODB recordsets.
>>> The code to automate testing of inserting and deleting is under
>>> development.
>>> And it is planned to be released over weekend.
>>>
>>> Here are two new success stories for the test - over 2010 cycles passed 
>>> OK
>>> (not my PC - others) - Access SP2 seems to be a solution:
>>>
>>> <<<+
>>> Test successfully finished.
>>>
>>> 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
>>> ->>>
>>>
>>> <<<+
>>> 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
>>> ->>>
>>>
>>> Shamil
>>>
>>> ----- Original Message ----- 
>>> From: "Shamil Salakhetdinov" <shamil at users.mns.ru>
>>> To: "Access Developers discussion and problem solving"
>>> <accessd at databaseadvisors.com>
>>> Sent: Thursday, March 23, 2006 8:32 AM
>>> Subject: Re: [AccessD] Access XP forms bound to ADO recordsets
>>>
>>>
>>>
>>>> Hi All,
>>>>
>>>> New version  (1.9.5) of the subject test released at
>>>>
>>>> http://smsconsulting.spb.ru/download/tests/a2dds.htm
>>>>
>>>> It collects complete MS Access process information (loaded DLLs) now 
>>>> and
>>>> writes it to XML file.
>>>> It also collects system information(menory usage, MS Access context and
>>>> locale) and writes into XML file.
>>>>
>>>> Both XML files are well formed and  can be imported into MS Access
>>>> database.
>>>>
>>>> Now it's possible to compare Access 2003 SP1 and Access 2003 SP2 and
>>>> related
>>>> DLLs versions to see which ones are upgraded in MS Access SP2...
>>>>
>>>> Shamil
>>>>
>>>>
>>> <<< tail skipped >>>
>>>
>>> -- 
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>>
>>
>>
>
> -- 
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com 




More information about the AccessD mailing list