>>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)?
Ben Rail
Business Solutions
LOGI.design