Hi Alex. The length of the field in RS1 is not correct -- you are trying to store a value that is too long. ADO generates an error in this case, rather than simply truncating. Set the empty country field to a string of the proper length for the field.

BTW, if you are using a disconnected recordset, in ADO 2.0 or above, you don't need the "as country" fake-out... just use the field collection's append command (RS.Fields.Append "Country", adChar, XX) to create a new field, then throw your data in there.

HTH.

Vin


>>The page fails saying "Errors found" and nothing else on the following line >>within the loop:

>>RS1.Fields("Country").Value = RS1.Fields("Country").Value
>> Note from Vin: I assume the above is an error, and the second "RS1" should say "RS2"

>>It does not matter what I put into the field, it always fails on the left >>side of the equation. The error does not specify anything more. I suspect it >>is a ReadOnly error but I opened the connection with adReadWrite and I tried >>all types of adLock parameters.