I have build an application for synchronizing tables between two NT 4 (SP6) servers.
I use SQL Queries to determine if records on the source server are newer than the records on the target server.

The problem i encounterd is that every morning the message appears : NOT ENOUGH DISKSPACE FOR C:\TEMP\TEMPFILE.TMP although there's 1,95 GB of diskspace.

Due to the large size of the tables the tempfile wil be also large so far i can understand the problem.

The question is :
Is there a possibility to delete the tempfile without shutting down the application. Trying to delete the tempfile while the application is running is not possible because FOXPRO is using the file.

Does anyone know how to tackle this problem


Thanks in advance

Eric de Bruin