ok I've gone for a clientside database stored procedure that appends and updates keys etc, I just use that in place of any append blank or insert that I would have had, that much is fine, infact all the code looks sound aside from updating the key table, can remote views not update numeric fields?!?

I have a table, it has a list of keynames(pkey Char) and values(numeric - these are the new pkeys for each keyname)

if I make a remote view on that and replace the value field with value + 1 then the update fails with a microsoft odbc syntax error

whats going on???

Ken.