[AccessD] Memory Leak in DAO?

Myke Myers mmmtbig at bellsouth.net
Mon Oct 25 13:48:16 CDT 2004


Does anyone see why the sub procedure below would result in an out of memory
condition when run about 100 times in a loop?


    Public Sub ExecuteActionQuery(strQueryName As String)

    Dim db As Database
    Dim qdf As QueryDef

    Set db = CurrentDb
    Set qdf = db.QueryDefs(strQueryName)
    qdf.Execute

    Set qdf = Nothing
    Set db = Nothing
    
    Exit Sub



TIA

Myke





More information about the AccessD mailing list