Try calling =SQLDisconnect(0). This will release cached connection handles. This also releases all active connections, so you only want to call it when there are no active connections. This is documented in the VFP7 help, but it works the same way in VFP6. You could also set SYS(3050) settings lower than the default to reduce the available memory allocated for data buffers.
Jim
Jim Saunders
Microsoft
This posting is provided “AS IS”, with no warranties, and confers no rights.
