>>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

I did solve the first problem... but My SQL string remains a problem.

How do I define a column, in a ADO data control's recordset, that do not get data from a table?

I feel as if I was going in circle :).