I am working with on application developed in VB6. Data are stored in an Access MDB file. Connection from application through ODBC.
Using a form with a TrueDBGrid grid control. Source for this grid is an ADODC control.
When changing SQL statement and doing a refresh to the dataset I approximately 1 out of 30 times receive an Automation error (-2147467259 Automation error Unspecified error) when doing a refresh to the ADODC control.
DataGeneesmiddelen.RecordSource = (gstrSQLSelectie)
DataGeneesmiddelen.Refresh ==> -2147467259 Automation error Unspecified error
Please some help!