>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
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
