Mike,
Check if you've the latest version of VFP ODBC driver. Create another table with the same structure and see if INSERT will work with it. Try insert in some other table. Try any other thing that can help in narrowing down a problem.
>The table has no index. I tried to do inserting from VFP command window and it works. Then I tried the program that inserts records in the table and it also works. There are times that the program does not work until I do inserting in VFP command window. How come this problem happens?
--sb--