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.