CAdodc ca;
C_Recordset rc;
ca.Create(_T("STATIC"), _T("Hi"), WS_CHILD | WS_VISIBLE, CRect(0, 0, 400, 200), this, 111);
ca.ShowWindow(SW_HIDE);
ca.SetConnectionString(_T("dsn=region_data;database=DB.mdb;"));
ca.SetRecordSource(_T("SELECT * FROM stuff_and_status_text"));
ca.Refresh();
cr=ca.GetRecordset();
cmg.ShowWindow(SW_SHOW); //cmg - CDataGrid
cmg.SetRefDataSource(cr);
cmg.UpdateData();