close tables all set multilocks on cursorsetprop("buffering",5,0) SQLSetProp(0,"DispLogin" ,3) SQLSetProp(0,"DispWarnings" ,.f.) * han = sqlconnect("mydsn","sa","") && get a valid connection SQLExec(han,"use pubs") SQLExec(han,"select * from authors","authors") SQLIdleDisconnect(han) Set step on *** stop the Ms-Sql Server =CURSORSETPROP("Tables", "authors") =CURSORSETPROP("UpdateNameList", "au_id authors.au_id, au_lname; authors.au_lname, au_fname authors.au_fname, phone; authors.phone, address authors.address,; city authors.city, state authors.state,; zip authors.zip, contract authors.contract") =CURSORSETPROP("KeyFieldList", "au_id") =CURSORSETPROP("UpdatableFieldList", "au_lname, au_fname, phone,; address, city, state, zip, contract") =CURSORSETPROP("SendUpdates", .T.) Browse && modify =TableUpdate(2,.t.,"authors") aerror(ae_authors) Display memory like ae_authorsWouldnt It be better if there is a better discription of the error ??