I'm using a remote view and ODBC connection to transfer data from VFP table to an Access table. The code seems to work fine until I go to close the view and I get an error message....

Connectivity error Microsoft ODBC Microsoft Access Driver Syntax error in Insert into statement

(I'm not using an insert into anywhere in the code.)

The error locks up VFP... I can't close the database....view... or even quit. I've looked in MDSN help and can't seem to find anything about that error. Any direction will be appreciated.