I'm trying to use 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

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.

So then, what have I done wrong?