How To Find Jet Database .mdb File Format Version (321329)

MORE INFORMATION

1. Copy the following code, and save it as FindJetVersion.cpp:

   #import "c:\program files\common files\system\ado\msado15.dll" rename_namespace("ado20") rename("EOF", "ADOEOF")
   using namespace ado20;
   
   struct HandleCOM
   {
   	HandleCOM()  { ::CoInitialize(NULL); }
   	~HandleCOM() { ::CoUninitialize();   }
   } _HandleCOM_;
   
   void main()
   {
      
   	
   	_bstr_t			bstrEmpty(L"");
       _ConnectionPtr cnDatabase(__uuidof(Connection));
      _bstr_t strConn( L""); 
   	
      strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=F:\\CustomerCode\\_DAO\\DatabaseConversionIssue\\testdbs\\test.mdb";
      
      HRESULT hr = cnDatabase->Open(strConn, bstrEmpty,bstrEmpty,-1);
   
   	if (cnDatabase->Properties->Item["Jet OLEDB:Engine Type"]->Value == (_variant_t)(long)5)
   		MessageBox(NULL,"It's Jet 4.0 Format Database","Jet File Format version",MB_OK);
   	else if
   	   (cnDatabase->Properties->Item["Jet OLEDB:Engine Type"]->Value == (_variant_t)(long)4)
   	   MessageBox(NULL,"It's lower than Jet 4.0 format Database","Jet File Format version",MB_OK);
   	else 
   		MessageBox(NULL,"Couldn't determine the version of Access File","Jet file version",MB_OK);
   
   }
   					

   NOTE: Depending on your system, you may have to change the paths for #import and file location.
   
   
2. On the File menu in Visual C++, click Open to open FindJetVersion.cpp that you just saved.
3. On the Build menu, click Build to build FindJetVersion.exe.
4. A dialog box appears with the following message:

   This build command requires an active project workspace. Would you like to create a default project workspace?
   						

   Click Yes to build FindJetVersion.exe.