I have a data grid control bound to an ADO data control on a VB form. When the form loads, the ADO data control's data source is refreshed.
The user will enter text in a text box and then click the search button. That button takes the text in the box and then uses it to build new SQL statement as the recordsource for the ADO data control. Then the data control is refreshed.
When I do that I get the error above. [ADODC]: Unknown error [ADO].
I did look on the KB and found two options. 1. Install latest VB Service Pack. Did that already. The other option was to make sure that the command type was set to adCmdText or adCmdUnknown. Did that too.
This started this afternoon. I know I was fiddling with the code at that point, but as far as I know, all I changed to make this happen was try to unbind the data grid from the ADO data control and try to bind it at run time. That didn't work so I rebound it at design time. Then I got the error. I repaired the database (Microsoft Access 2000) and also created a new grid control and a new ADO data control and redid the code. No luck.
Any ideas? Thanks in advance!!!