C / C++ / MFC

<br />
CDaoDatabase db;<br />
db.Open("DatabaseFileName.mdb", ...other parms...);<br />
<br />
CDaoTableDef td(&db);<br />
td.Open("MyTable");<br />
<br />
for(int i = 0; i < td.GetFieldCount(); i++){<br />
    CDaoFieldInfo fi;<br />
    td.GetFieldInfo(i, &fi);<br />
<br />
    // The field's name will be in fi.m_strName;<br />
    TRACE(_T("Field[%d]: %s\n"), i, fi.m_strName);<br />
}<br />
<br />
td.Close();<br />
db.Close();<br />

CDaoDatabase db;
db.Open("AccessFileName.mdb", ...);

CDaoTableDef td;
td.Open("MyTable");

CDaoRecordset set(&db);
set.Open(&td);

// To fetch the total number of records in the table...
int nNumRecords = set.GetRecordCount();

// Step to the 5th record...
// NOTE: This moves 5 records forward from the current record.
set.Move(5); 

// Fetch the contents of the 'Name' field. 
COleVariant var;
set.GetFieldValue(_T("Name"), var);

// Move to the 8th record.  We're currently positioned on 
// the 5th record, so we need to move forward 3 rows.
set.Move(3); 

// Fetch the contents of the 'Name' field. 
set.GetFieldValue(_T("Name"), var);

set.Close();
td.Close();
db.Close();