[AccessD] Access XP forms bound to ADO recordsets

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Fri Mar 24 11:05:36 CST 2006


Well, let us know when the new version is ready.  And I'll run both the 
mdb and the adp.  I have a lot of idle cycles on the weekend. :-)  
(Computer has some, too)

Rocky


Shamil Salakhetdinov wrote:
> 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 
>>     
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com




More information about the AccessD mailing list