>>> I see your pount. I'll try again but it was a typo. I was using 12 spaces between quotes AS country. (BTW don't they have a Space(12) function?) >>
>
>Which provider are you using? I don't even know which back-end (did you mention before?)
>
>At any rate, let me know how this works out....
>
>Vin
See my reply to J. Crescencio on how the problem was fixed. The database is SQL7.
ADO does makes dummy fields (spaces as columnname) readonly if they are not based on real fields. I added an unused table field to the query AS MyColumnName and it worked.
Note that if you use SELECT ... FROM ... Field1, Field1 as MyField you can't do it as ADO makes MyField readonly too.
In my case I did:
SELECT ... FROM ... Field1, Field2, AnotherExistingUnneededField AS Country
That made it readwrite so I coukld then change the record.value in that recordset.