>>>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
Igor Gelin
Database Developer