Hi David,
The tmp file gets created during the applications runtime, it's hard to say when but definitely not at the startup of the app.
Thanks for the advice with the foxuser.dbf/fpt - I'll give it a try ASAP.
>Robert,
>
>So does the huge tmp file show up as soon as the app starts or only after the user does some operation? I guess it's possible you have a corrupt foxuser.dbf/fpt on the box you might try deleting it.
>
>>Yes we're sure the temp file belongs to our VFP application.
>>Deleting the temp file is only possible if you kill the application otherwise it is in use.
>>
>>It's not quite sure which sql command causes the problem, but there should only be simple select (joins, unions, ...), insert, update and delete commands - nothing really special.
robert.oh.