Shamil Salakhetdinov
shamil at users.mns.ru
Fri Mar 24 23:41:00 CST 2006
John, Something is wrong with your installation I think. I did run the test with MS Access XP and it worked OK for 500 cycles, memory alloaction was ~46MB. <<< ADODB Bound Forms Crash Test v.1.9.8 [25-MAR-06] Test successfully finished. Backend: MS Access Binding: ADODB Cycles to pass: 500 Cycles passed: 500 Total errors: 0 Forms opened: 2500 Start time: 25.03.2006 7:53:05 End time: 25.03.2006 8:21:10 Object statistics: ClassName = CTestForm, Created = 6, Disposed = 6 ClassName = CFormDataset, Created = 23221, Disposed = 23220 >>> I have another system where MS Access XP doesn't work that good. We can compare what are the differences between your system and mine - the test creates a2dds_mdb_process.xml with the information about all the used DLLs etc. - this XML can be imported into MS Access mdb etc. - i.e. we can find the differences of our installations and what part of this installation creates the trouble. But the best and easiest looks like using MS Access 2003 SP2. The other systems create trouble, which doesn't worth (at least here) to spend time on guessing how to workaround, at least until MS Access 2003 SP2 will work stable for all teh update modes (inserts, update, delete) - currently only update is tested automatically and insert and delete can be tested manually for Customers form, which doesn't have Autonumber.... Shamil ----- Original Message ----- From: "John Colby" <jwcolby at ColbyConsulting.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Saturday, March 25, 2006 4:46 AM Subject: Re: [AccessD] Access XP forms bound to ADO recordsets > Shamil, > > I got a "not enough memory" error message on the 69th pass. AXP. I sent > the error email and the XML File. Access is using 182 meg after the > close. > Looks like a memory leak perhaps. I will start over and watch the Access > instance in Task Manager. > > What I have discovered by watching task manager while stepping through the > code is that this code: > > 480 For i = 1 To 3 > ' set form controls values > 490 TrashForm accApp, frm > 500 For Each ectl In frm.Controls > 510 If Len(ControlSource(ectl)) > 0 Then > 520 If ectl.ControlSource = avar(lngIdx + 1) Then > 'Debug.Print avar(lngIdx) & "." & avar(lngIdx > + 1) > 530 Else > 540 If UsualFormBinding = False Then 'ss:17mar06 > 550 FakeSetControlValue ectl > 560 End If > 570 End If > 580 End If > 590 Next ectl > 600 Next I > > Is adding memory on line 550 and then when it cycles back up to 490 it > adds > still more memory. This memory does not appear to be returned. I am > wondering if the container is expanding and the Access instance is adding > memory to hold pieces or something. > > I do know that the TrashForm is adding memory occasionally at line 30 > > 30 Set rst = rfrm.RecordsetClone > > And again occasionally when the rfrm.bookmark is set. > > I added code to close the rst (pointer to recordsetclone) and set it to > nothing but that does NOT return the memory. > > I added a > > while 1 > trashform > Wend > > And the memory just climbs steadily. > I don't have an answer to why, nor how to get the memory back. With the > > rst.close; set rst = nothing > > In TrashForm I have added the only thing I can think of to coax the system > to give it back and no dice. > > > 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 24, 2006 6:30 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access XP forms bound to ADO recordsets > > Hi All, > > New version (1.9.8) is published - > http://smsconsulting.spb.ru/download/tests/a2dds.htm. > > It should give more detailed results about errors if they appear. > > Make your PCs busy over weekend! :) > > 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 8:05 PM > Subject: Re: [AccessD] Access XP forms bound to ADO recordsets > > >> 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 >> >> > <<< tail skipped >>> > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com