🚀 go-pugleaf

I am creating a database app to access and manipulate a MS Access database.

The code that am using is seen below.

When I compile and run this app, I get the following error:

Project MyProject.exe raised exception class EOLeException with message 'Current provider does not support the necessary interface for Index functionality.'

What do I need to do to get around this ?

Pete
PS: Using CBuilder 6.

void __fastcall TfMain::Button_MergeClick(TObject *Sender)
{
  String Str;
  const String ConnStr_Master = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + MasterPATH;
  const String ConnStr_Source = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + SourcePATH;

  ADOConnection_Master -> ConnectionString = ConnStr_Master;
  ADOConnection_Source -> ConnectionString = ConnStr_Source;

  ADOTable_Master -> TableName = "MACHINE";
  ADOTable_Master -> IndexName = "Serial_Number";
  ADOTable_Master -> Open();

  ADODataSet_Source -> CommandText = "SELECT * FROM Machine";
  ADODataSet_Source -> Open();

  ADODataSet_Source -> First();


  while (!ADODataSet_Source -> Eof)
   {
    Str = ADODataSet_Source -> FieldValues["Serial_Number"];
    ADOTable_Master -> Seek(Str, soFirstEQ);

    ADODataSet_Source -> Next();
   };
}