HankWalters
MIS
I have an app that was converted from Access 2000 to Access 2007. There is a form with a subform that is bound to an ADODB.Recordset in code (Set Me.frmQuoteLookupSubFormTract.Form.Recordset = rstFormSource). This is done just as is shown in the Access Help topic. The subform is a datasheet view of the data.
My problem occurs when I try to sort the data in the subform. I can click on a field, click on the A-Z sort, and it will work the first time only. Any sort after that always generates the error "Data provider could not be initialized".
This did not happen in the Access 2000 version. In that version of the app, you could sort it as many times as you wanted, any way you wanted.
Any ideas on why this works in Access 2000 but gives this error on any sort other than the first one in Access 2007?
Thanks!
Hank
My problem occurs when I try to sort the data in the subform. I can click on a field, click on the A-Z sort, and it will work the first time only. Any sort after that always generates the error "Data provider could not be initialized".
This did not happen in the Access 2000 version. In that version of the app, you could sort it as many times as you wanted, any way you wanted.
Any ideas on why this works in Access 2000 but gives this error on any sort other than the first one in Access 2007?
Thanks!
Hank
