C / C++ / MFC

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();

void MyDialog::OnOK()
{
	// suppose m_sPassword is bound with DDX to the editbox
	UpdateData( TRUE );

	if( m_sPassword != "PASSWORD" )
	{
		AfxMessageBox( "Wrong Password" );
		return;
	}

	CDialog::OnOK();
}