>Just close the table every once in a while and re-open it afterwards. The same applies to table with large index files - over time Fox will pull more and more of the CDXes into memory and this can lead to RAM starvation. This can be confusing because the symptoms look exactly like those of a memory leak ...

Hi Stephan
actually my application is part of a bigger program and this part is in a timer that is running once every 6 hour and the Back-up table is open only during the 5 seconds back-up time and I'm closing it afterward. I'm sure that the table is correctly close because after the back-up I'm moving it elsewhere. After each INSERT INTO line I'm using the SYS(1104) command line to flush the memory.