[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