🚀 go-pugleaf

I've encountered a problem with ADO and Access:

My access database has five tables, each table as multiple indices.

I'm using a TADOConnection and a TADOTable to access the MS Access DB; code
below used to setup the objects:

#define CONNECT_STRING_FMT     "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=%s;User Id=admin;Password="

            // Create a DB Connection COM Object Instance
            mpConnection = new TADOConnection(NULL);
            mpConnection->ConnectOptions = coConnectUnspecified;
            mpConnection->CursorLocation = clUseClient;
            mpConnection->IsolationLevel = ilCursorStability;
            mpConnection->LoginPrompt = false;
            mpConnection->Mode = cmShareDenyNone;
            strConnectionString = Format(CONNECT_STRING_FMT,
OPENARRAY(TVarRec, (strMediaLibraryDBPath)));
            mpConnection->ConnectionString = strConnectionString;
            mpConnection->Connected = true;

            // Create a Table Object Instance for the Container Table
            mpContainerTable = new TADOTable(NULL);
            mpContainerTable->Active = false;
            mpContainerTable->Connection = mpConnection;
            mpContainerTable->CursorType = ctKeyset;
            mpContainerTable->TableName  = TABLE_NAME_CONTAINER;
            mpContainerTable->IndexName  = INDEX_NAME_PRIMARY;
            mpContainerTable->Active = true;

            {  ... repeat for each addition table...  }

I intend on doing all of the normal database management stuff:  a)  add,
modify and delete records, b) search tables using various indices, c)
transaction bracketing, etc.  What method is recommended for doing
index-based search using a relational operator?

example:  get record whose parentID >= 10

In DAO, the recordset.seek() allows a relational operator on one or more key
values against the current index.  Is there an equivalent?

Thanks in advance for your help.

Regards;

Al Dube