🚀 go-pugleaf

I'm converting an application that used the BDE with access to use ADO 
with access. I'm having a bit of difficulty when it comes to recognizing 
the methods with ADO that correspond to the methods used in BDE.

I'm using a TADOconnection with TADOTables set to table direct.

I use BDE Set Key() and  GotoKey() to extract data from linked tables. I 
would assume there is a similiar method with ADO but I'm not sure which 
they are. All I want to do there is set the current record and goto it.

Also, for some reason, when I loop thru records it seems to go very very 
slow compared to the BDE version. Perhaps I'm not using the right methods.

    if(datamod->Table1->FindFirst())
    {
       do
       {
          Application->ProcessMessages();


          datamod->Table1->FieldValues["T_FIELD"]   = 0;
          //...

       }while(datamod->Table1->FindNext());
     }

I don't have much experience with ADO (This is my first app really) if 
anyone has any insight or can point me to a good resource to learn more 
about the ADO basics I'd be grateful.