You are currently offline, waiting for your internet to reconnect

INFO: Accessing CREATE_DB, REPAIR_DB, and COMPACT_DB

This article was previously published under Q126606
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
SUMMARY
The Help file for the ODBC version 2.0 Desktop Drivers mentions that theMicrosoft Access driver accepts the keywords CREATE_DB, REPAIR_DB, andCOMPACT_DB on the lpszAttributes parameter, but gives no details on theirsyntax.
MORE INFORMATION
The SQLConfigDataSource lpszAttributes keywords CREATE_DB, REPAIR_DB, andCOMPACT_DB cannot be used in conjunction with other keywords. If you wantyour programs to create a datasource and also create a new .MDB file forthat datasource, you must do this in a two stage process. You must createthe datasource on one call to SQLConfigDataSource, and create the new .MDBfile on a separate call to SQLConfigDataSource.

The syntax for these keywords are:
   CREATE_DB=<path name> <sort order>   REPAIR_DB=<path name>   COMPACT_DB=<source path> <destination path> <sort order>				
<path name> is the fully qualified path name to the .MDB file to be created or repaired. <source path> is the fully qualified path name to the .MDB file to be compacted. <destination path> is the fully qualified path name of the file after it has been compacted. <sort order> is one of the following keywords:
General, Traditional Spanish, Dutch, Swedish/Finnish, Norwegian/Danish, Icelandic, Czech, Hungarian, Polish, Russian, Turkish, Arabic, Hebrew, Greek
NOTE: The General sort order covers English, French, German,Portuguese, and Italian.

Depending on the version of the Microsoft Jet Engine used by the Microsoft Access ODBC driver the following keywords may also be available:
CREATE_DBV2=<path name> <sort order> (to create version 2 Jet engine mdb file, Access 2, 16bit)CREATE_DBV3=<path name> <sort order> (to create version 3 Jet engine mdb file, Access 95, Access 97)CREATE_DBV4=<path name> <sort order> (to create version 4 Jet engine mdb file, Access 2000)					
For additional information on these and other keywords, see the MSDN or the Microsoft Press book, Microsoft Jet Database Engine Programmer's Guide.

NOTE: Some versions of the documentation incorrectly spell CREATE_DBV2 and are missing descriptions for CREATE_DBV3 and CREATE_DBV4.

With CREATE_DB, the file named in <path name> must not exist at the timeSQLCOnfigDataSource is called.

With REPAIR_DB, the file named in <path name> must be a valid .MDB file.

With COMPACT_DB, the file named in <source path> must be a valid .MDB file.<destination path> can point to the same file as <source path>, in whichcase the file will be compacted into the same location. If <destinationpath> names a different file than <source path>, the file named as the<destination path> must not exist at the time SQLConfigDataSource iscalled.

For example, the following code segment would create a .MDB file, repairit, compress it to a second file, compress it in the same location, andthen create a datasource for it.
   void Config_Sample(void)   {             RETCODE retcode;             int     subscrp;     extern  HWND    hWnd;      /* Main window handle. */      UCHAR szDriver[] = "Microsoft Access Driver (*.mdb)";     UCHAR *szAttributes2[] =     // Create the original .mdb file.     {"CREATE_DB=c:\\odbcsdk\\smpldata\\access\\general.mdb General\0\0",     // Issue a REPAIR_DB on the created file.     "REPAIR_DB=c:\\odbcsdk\\smpldata\\access\\general.mdb\0\0",     // Compact the file into a new location.     "COMPACT_DB=c:\\odbcsdk\\smpldata\\access\\general.mdb "       "c:\\odbcsdk\\smpldata\\access\\general2.mdb General\0\0",     // Compact the file onto itself.     "COMPACT_DB=c:\\odbcsdk\\smpldata\\access\\general.mdb "       "c:\\odbcsdk\\smpldata\\access\\general.mdb General\0\0",     // Create a datasource for the first .mdb file created.     "DSN=albacc\0FIL=MS Access\0JetIniPath=odbcddp.ini\0"     "DBQ=c:\\odbcsdk\\smpldata\\access\\general.mdb\0"     "DefaultDir=c:\\odbcsdk\\smpldata\\access\0\0"};     for (subscrp = 0;          subscrp <= ((sizeof szAttributes2 / sizeof(UCHAR *)) - 1);           subscrp++)     {       retcode = SQLConfigDataSource(hWnd,                                     ODBC_ADD_DSN,                                     szDriver,                                     szAttributes2[subscrp]);       if (retcode != TRUE)         handle_error(retcode);     }     return;   }				
2.00.2317 Windows NT SQLConfigDataSource desktop driver access
Properties

Article ID: 126606 - Last Review: 06/12/2001 22:54:00 - Revision: 1.0

Microsoft Open Database Connectivity 2.0, Microsoft Open Database Connectivity 3.0, Microsoft Open Database Connectivity 3.5

  • kbcode kbinfo kbprogramming kbusage KB126606
Feedback
ar varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" /html>="setLanguage(language);" class="ng-binding" id="language-es-es">España - Español
Paraguay - Español
Venezuela - Español
id=1&t=">&did=1&t="> var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write(" /html>appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> >>