>>Hey Alex. Y'know, I've always used Fields.Append with an RS I created from scratch... maybe it can't be used with an RS that has an active connection.
>>
>>Anyway, going back to your original code, I still think the length of the country field you have added is the issue. I base this mainly on the fact that it is exactly the error when I have gotten this message before, and in your original post you said you added the following line to your query:
>>
>>'' as country
>
>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?)

Hi Alex,

I was trying to do something similar in VB this weekend. I think the problem is you can't just add a field to a connected recordset. I tried to just use "junk" as ExtraColumn, but it would always error when I tried to replace any data in it. See :
Forum: Visual Basic and VB.Net Category: Database DAO/RDO/ODBC/ADO Title: Re: How to add a temporary field to an ADO rs Thread #517413 Message #517538 for a possible solution. It uses a shaped recordset to get around the problem.

hth