Sorry Ashley,
My post didn't show up like I had hoped as I used angle brackets, so here goes again: SELECT fldname AS newfieldname FROM ....
>Hi Ashley,
>I don't know if it will work but try aliasing the field name as in:
>select
as >
>Larry
>
>>I have a problem with a link I am putting into and old Access 2.0 database. One of the Access tables has a fieldname with a numeric as its first character, this is fine in access but poor old Fox has a fit. I have tried renameing the field with CursorSetProp("UpdateNameList",, ) but I am still getting connectivity errors when I try to update the Access table.
>>
>>Does anyone know how I can do this??
>>
>>Many thanks
>>
>>Ashley
>>AssureSoft