Unanswered: (VB6) Adodc and textboxes no longer working
I was creating a form with an ActiveX data control (ADODC) and some textboxes in VB6: the textboxes' Datasource property is set to Adodc1, each of them's Datafield property is set to a field in Adodc1.
And the Adodc1 is set to a table in a certain Access database.
It used to require NO coding at all to show the records in the textboxes.
All I need to do was to press F5 and then the textboxes would be filled with data.
But after a while, it suddenly stopped working - the textboxes become empty now.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert
I solved the problem by re-installing VB6. Perhaps I REMOVED some REFERENCES previously.
Your suggestion (to use ADO recordset instead) is helpful.
The ADODC was NOT able to lock records even though I set its lock type to "Pessimistic". But when I started using ADO recordset, it CAN lock records.