>Has anyone had any problems with file locking or file in use by another when using INSERT INTO. I have been getting this in a dos 2.6 app. Any Ideas
>

Any time you issue a command that adds a record to a table, the header of that table is locked for a short time while VFP updates the record count in the header. This should generally not be a problem, especially with SQL INSERT because the amount of time that the header is locked is very small. Are you getting the error when you use the INSERT, or is the SQL INSERT causing the error in other processes?

Things to watch for:

REPLACE FOR/ALL
DELETE FOR/ALL

these commands lock the table header for the duration of their execution, which can often cause contention.