I've tried aliasing the field name and still no joy. here is what is happending:

create sql view Polh Remote connection Policies as ;
select id, Branch, Propnum, clientcode, licocode, classcode, ;
eventcode, policynum, termyears, riskdate, maturitydate, ;
"1st_2ndDeathBenefit" as DeathBen ;
from PolHistory

1st_2nd Deathbenefit is the problem field. A digit as the first char. If I leave things as they are at this point, I can update the contents of this field by changing its alias "DeathBen". All looks well but when you see the table back in Access, no changes have been made. So I have added the following:

cursorsetprop("KeyFieldList","Branch, PropNum, ClientCode")
cursorsetprop("UpdateNameList","DeathBen Polh.1st_2ndDeathBenefit)
cursorsetprop("Sendupdates",.T.)
cursorsetprop("Tables","PolH")
cursorsetprop("UpdatableFieldList","Deathben")

All seems well at this point, you can add and change the contents of the DeathBen field, but as soon as i try to update, I get connectivity errors.

I am sure I cant be far from the solution, but it is a Friday, Ive got a headache and this is my first foray into ODBC.

Any help would be monumentally appreciated.

Ashley
Assuresoft.