>>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.
>
>The few times I've seen this error it was always a corrupt MDAC. Get the latest MDAC from Microsoft (
http://www.microsoft.com/data) and load it. See if that solves your problem.
>
>HTH
Actually, I solved it but not sure as to why it is.
The SQL string that I used to build my recordset was querying fields from 2 tables and was also adding 4 columns (not related to any table). These fields were set to Null and the result was a recordset with 4 filled fields and 4 empty, non-related, fields.
I realized that the error would occur only on the 4 non-related fields so I changed my SQL string and replace the Null with a table field. The problem disapears and I can update my recordset.
Why it is ... I'm not sure since my recordset is disconnected.
Any comments would be appreciated.
Ben Rail
Business Solutions
LOGI.design