>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?)