[AccessD] Access XP forms bound to ADO recordsets

Shamil Salakhetdinov shamil at users.mns.ru
Tue Mar 21 06:41:13 CST 2006


> You should select a loop count beyond 2011 as Shamil experiences an error 
> at that loop ...
Thank yoy, Gustav,

Yes the error happens on loop count = 2010 - 2012

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
ADODB Bound Forms Crash Test v.1.9.2 [20-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: 5000
Cycles passed: 2012
Total errors: 1
Forms opened:  10059
Start time:    20.03.2006 16:46:38
End time:      20.03.2006 19:55:32

Object statistics:
ClassName = CTestForm, Created = 6, Disposed = 6
ClassName = CFormDataset, Created = 71988, Disposed = 71988
>>>>>>>>>

When I'm then trying to close and to reopen database window without quitting 
MS Access I'm getting this weird message:

<<<
Microsoft Office Access was unable to create the Database window
Please upgrade to a newer version of Microsoft Internet Explorer
>>>

System statistics do not show that some of the resource exhausted or 
something like that:

<<<
MS Access: 36MB
Northwind mdb size: Start: ~4MB  On error: ~67MB
Total Paging File Size on all drives: 1536MB

CPU usage: 4%
PF Usage: 890 MB

Totals:
  Handles: 14590
 Threads     664
  Processes: 57
Commit Change (K)
  Total    912084
  Limit   2532840
  Peak  990096
Physical Memory (K)
  Total  1048020
  Available  163200
  System Cache 352524
Kernel Memory
  Total   78276
  Paged 59564
  Nonpaged 18712

Test application HDD:: Total: 7.99GB  Free 3.87GB
System HDD:  Total 31.2GB  Free 4.41GB
>>>>

Strange, very strange.
I did set breakpoint on error and I did check are there any hidden 
non-closed forms in the Forms collection or (occasionally) non closed 
databases in dbengine(0).Databases collection etc. - all seems to be 
clean....

Shamil

----- Original Message ----- 
From: "Gustav Brock" <Gustav at cactus.dk>
To: <accessd at databaseadvisors.com>
Sent: Monday, March 20, 2006 9:11 PM
Subject: Re: [AccessD] Access XP forms bound to ADO recordsets


> Hi all
>
> If you have a few spare moments I could recommend to download and run this 
> test. It's very easy to do - Shamil has prepared everything - you just 
> need a copy of Nortwind.mdb for A2000.
> You should select a loop count beyond 2011 as Shamil experiences an error 
> at that loop ...
>
> /gustav
>
<<< tail skipped >>> 




More information about the AccessD mailing list