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