>>>>Hi,
>>>>
>>>>I'm using an adodc data control (retrieving data from Access) that's binded to a datagrid object.
>>>>
>>>>The data control has 7 columns but only 2 that are populated. The rest of the columns could be populated by the user. These columns would be populated through a series of textboxes giving choices to users according to each column.
>>>>
>>>>I thought that the following command would edit a row of the recordset (that is, the user scrolls through the grid positionning cursor on the appropriate record):
>>>>Adodc1.Recordset("Region").Value = "East"
>>>>
>>>>But I get the following error (translated from french):
>>>>A multi-steps operation generated errors. Verify each status value: #2147217887.
>>>>
>>>>What should I look at?
>>>>Can I edit (and even add record) column in and adodc recordset?
>>>>
>>>>TIA.
>>>
>>>Possibly MS Access table refused to save the data, because it breaks data validation rules.
>>>You may check AllowZeroLength property of text fields in your table, if it set to "No" make sure that you provided valid data, but not "".
>>>
>>>HTH, Igor
>>
>>Oups... forgot to say that my recordset is disconnected.
>>When disconnected isn't it only the recordset that gets updated (not the database)?
>
>I beleive, you may change fields'properties even for disconnected recordsets. If you want a field to be able to accept Null values, set the field's property to adFldIsNullable.
>
>HTH, Igor


It is the other way around :). The fields are set with Null values; It is when I try to replace these Null values with something else that the problem occurs.

I looked into your suggestion of changing field properties. Reading up on it, I found that I could add fields to the recordset (may be instead of definition in SQL string). Somehow they do not show up in the fields collection (even after I closed the recordset, appended the fields and refreshed the fields collection - as they say in the docs).

So I guess I've got some more reading to do.

Thanks.