C / C++ / MFC

	_RecordsetPtr records = NULL;
	 records.CreateInstance(__uuidof(Recordset));

	try
	{
		records->CursorType = adOpenStatic;
		records->CursorLocation = adUseClient;
		records->Open("SELECT * FROM FileDatabase",
		_variant_t((IDispatch*)m_Connection, true), adOpenKeyset, adLockOptimistic, 
		adCmdUnknown);
	}
	catch(...)//_com_error & e)
	{
//		MessageBox(NULL, e.ErrorMessage(), "", 0);
	}

	if (records->RecordCount == 0) return S_FALSE;

	records->MoveFirst();

for (it = vecFileEntries.begin(); it != vecFileEntries.end(); ++it)
{
    // Get everything in order first
    if (records->RecordCount != 0)
        records->MoveFirst();

    CComBSTR bstrPath;
    (*it)->get_FilePath(&bstrPath);

    char * pStr = new char[bstrPath.Length() + 24];
    memset(pStr, 0, bstrPath.Length() + 24);
    sprintf(pStr, "[FilePath] = \'%s\'", (char*)(_bstr_t)bstrPath);

    try
    {
        records->Filter = (bstr_t)pStr;
    }
    catch (.../*_com_error & e*/)
    {
        MessageBox(NULL, "Error", pStr, 0);
    }

    if (records->adoEOF)
    {

HRESULT hr = S_OK;

// Define ADOX object pointers.
// Initialize pointers on define.
// These are in the ADOX::  namespace.
ADOX::_CatalogPtr m_pCatalog = NULL;
ADOX::_TablePtr   m_pTable   = NULL;

try
{
    TESTHR(hr = m_pCatalog.CreateInstance(__uuidof(ADOX::Catalog)));

    char * pChar = new char[400];
    memset(pChar, 0, 400);
    sprintf(pChar, "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Engine Type=4;Data Source=%s;", (char*)DatabasePath);

    //Open the catalog
    m_pCatalog->Create(pChar);
    delete [] pChar;

    TESTHR(hr = m_pTable.CreateInstance(__uuidof(ADOX::Table)));
    m_pTable->PutName("FileDatabase");
    m_pTable->Columns->Append("FileName",ADOX::adVarWChar, 255);
    m_pTable->Columns->Append("FilePath",ADOX::adVarWChar,255);
    m_pTable->Columns->Append("FileLength",ADOX::adInteger,0);
    m_pTable->Columns->Append("TimesDownloaded",ADOX::adInteger,0);
    m_pTable->Columns->Append("LastModified",ADOX::adInteger,0);
    m_pTable->Columns->Append("Frames",ADOX::adInteger,0);
    m_pTable->Columns->Append("Seconds",ADOX::adInteger,0);
    m_pTable->Columns->Append("Width",ADOX::adInteger,0);
    m_pTable->Columns->Append("Height",ADOX::adInteger,0);
    m_pCatalog->Tables->Append(
        _variant_t((IDispatch *)m_pTable));

}

catch(_com_error &e)
{
    // Notify the user of errors if any.
    _bstr_t bstrSource(e.Source());
    _bstr_t bstrDescription(e.Description());

    MessageBox(NULL, bstrDescription, bstrSource, 0);

    return E_FAIL;
}

catch (...)
{
    MessageBox(NULL, "General Error Creating Database", "Error", 0);
    return E_FAIL;
}

return S_OK;