> Has anyone experience any memory leak using ADO in VFP especially working with hierarchical recordset???

There can be situations where the VFP/ADO combination appears to leak. I've concluded that it's ADO caching stuff. VB shows the same behavior using the same scenarios.