C / C++ / MFC

#include <afxdao.h>

//
#import "C:\\Program Files\\Common Files\\Microsoft Shared\\OFFICE12\\MSO.DLL" 

using namespace Office;

#import "C:\\Program Files\\Common Files\\Microsoft Shared\\VBA\\VBA6\\VBE6EXT.OLB"

using namespace VBIDE;

#import "C:\\Program Files\\Microsoft Office\\OFFICE11\\EXCEL.EXE" \
	rename( "DialogBox", "ExcelDialogBox" ) \
	rename( "RGB", "ExcelRGB" ) \
	rename( "CopyFile", "ExcelCopyFile" ) \
	rename( "ReplaceText", "ExcelReplaceText" )

 _CatalogPtr m_pCatalog  = NULL;
				 CoInitialize(NULL);
		         m_pCatalog.CreateInstance(__uuidof (Catalog));
			
m_pCatalog->Create((const char *)(CString("Provider =Microsoft.Jet.OLEDB.4.0;Data Source=" + csAccessDbname)));

UserRs.Open(CRecordset::snapshot,Sql,CRecordset::none);

try
	{
		  UserCn.OpenEx(_T("Driver={Microsoft Access Driver (*.mdb)};" "Dbq=" + csAccessDbname + ";"),CDatabase::noOdbcDialog);  
	  }
           //Exception occurd here
	  UserRs.Open(CRecordset::snapshot,Sql,CRecordset::none);	  
	}	
	catch(CDBException cdb)
	{ 
	  MessageBox(NULL,cdb.m_strError ,"fnInitFromFile_CDBException",0);
	}
	catch(CException ce)
	{
	  AfxMessageBox(ce.ReportError());	  
	  AfxMessageBox("CException..inside fnInitFromFile");
	}
	catch(...)
	{ 	  //Exception caught here
	  MessageBox(NULL,"CRecordSetfailed.. ","fnInitFromFile_Exception",0);	  	  
	}