Create method example (VC++)
Applies to: Access 2013, Office 2013
The following code shows how to create a new Microsoft Jet database with the Create method.
// BeginCreateDatabaseCpp
#import "c:\Program Files\Common Files\system\ado\msadox.dll" no_namespace
#import "c:\Program Files\Common Files\system\ado\msado15.dll"
#define TESTHR(x) if FAILED(x) _com_issue_error(x);
#include "iostream.h"
#include "stdio.h"
#include "conio.h"
//Function declarations
void CreateDatabaseX(void);
//------------------------------------------------------------//
//Main Function
//Purpose: Test Driver
//------------------------------------------------------------//
void main()
{
HRESULT hr = S_OK;
hr = ::CoInitialize(NULL);
if(SUCCEEDED(hr))
{
CreateDatabaseX();
//Wait here for the user to see the output
printf("Press any key to continue...");
getch();
::CoUninitialize();
}
}
//------------------------------------------------------------//
//CreateDatabaseX
//Purpose: create a new Jet database with the Create method
//------------------------------------------------------------//
void CreateDatabaseX()
{
HRESULT hr = S_OK;
// Define ADOX object pointers.
// Initialize pointers on define.
// These are in the ADOX:: namespace.
_CatalogPtr m_pCatalog = NULL;
//Set ActiveConnection of Catalog to this string
_bstr_t strcnn("Provider='Microsoft.JET.OLEDB.4.0';"
"Data source = c:\\new.mdb");
try
{
TESTHR(hr = m_pCatalog.CreateInstance(__uuidof (Catalog)));
m_pCatalog->Create(strcnn);
printf("Database 'c:\\new.mdb' is created.\n");
}
catch(_com_error &e)
{
// Notify the user of errors if any.
_bstr_t bstrSource(e.Source());
_bstr_t bstrDescription(e.Description());
printf("\n\tSource : %s \n\tdescription : %s \n ",
(LPCSTR)bstrSource,(LPCSTR)bstrDescription);
}
catch(...)
{
cout << "Error occured in CreateDatabaseX...."<< endl;
}
}
// EndCreateDatabaseCpp