I do so MUCH appreciate your help!!!!

I was able to select the Send Update as you mention, but NOW, I get an SQL error that messes up FoxPro. I can not even type the Quit command without the error.

Below is the program I am running. It locks up on the Copy to command, but it ads records and the browse before it works FINE.

The error is EXACTLY

Connectivity error: [Microsoft][ODBC SQL Server][SQL Server] Incorrect syntax near the keyword ‘level’



set safe on
set defa to z:\source
set talk on
close database all
OPEN DATABASE z:\source\test.dbc shar
use joel_empl
STORE "A1" TO M.ID
STORE "Joel" TO M.NAME
STORE "X12" TO M.LEVEL
INSERT INTO JOEL_EMPL FROM MEMVAR
BROW
copy to temptest
close database all
use temptest
brow