[AccessD] Access XP forms bound to ADO recordsets

John Colby jwcolby at ColbyConsulting.com
Fri Mar 17 11:57:54 CST 2006


I would like to look at this over the weekend. 


John W. Colby
www.ColbyConsulting.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
Salakhetdinov
Sent: Friday, March 17, 2006 12:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access XP forms bound to ADO recordsets

Hi All,

New version ob subject tests is available at
http://smsconsulting.spb.ru/download/tests/a2dds.htm
Currently there is a weird problem when running in "usual binding mode" with
MS Access backend and no any data updates - GPF
http://smsconsulting.spb.ru/download/tests/gpf.jpg.

It would be very useful if somebody approved/disapproved this problem by
running the tests on their PC.

Thank you.

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 16, 2006 10:42 PM
Subject: Re: [AccessD] Access XP forms bound to ADO recordsets


> Hi All,
>
> There is newer version of subject test available at
> http://smsconsulting.spb.ru/download/tests/a2dds.htm
>
> If you will have some time when your compute will be free over weekend
> please run it.
>
> I will try to consistently enlarge/improve this test set.
>
> Some users report it runs OK, e.g.:
>
> <<<
> Connection = Provider=SQLOLEDB.1;
> Connection Timeout = 5;
> Server=<SERVERNAME>\SQLEXPRESS;
> Database=Northwind;
> Integrated Security = SSPI;
>
> Test successfully finished.
> Backend: MS SQL
> Cycles to pass: 2500
> Cycles passed: 2500
> Forms opened: 12500
> Start time: 3/15/2006 5:03:45 PM
> End time: 3/15/2006 6:11:13 PM
>>>>
>
> It (latest version) currently gives me trouble for MS Access 2003 backend
> after about 2000+ cycles:
>
> <<<
> ADODB Bound Forms Crash Test v.1.9 [16-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: 2300
> Cycles passed: 2012
> Forms opened:  10059
> Start time:    16.03.2006 20:25:57
> End time:      16.03.2006 22:07:35
>
> Object statistics:
> ClassName = CTestForm, Created = 6, Disposed = 6
> ClassName = CFormDataset, Created = 71639, Disposed = 71639
>>>>
>
> It would be useful to have more statistics to find stable workarounds 
> and/or
> define the set of environments where this test doesn't run OK.
>
> Thank you in advance for any feedback.
> Shamil

<<< tail skipped >>> 

-- 
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