DOC: Format of the Password Parameter for CompactDatabase

• The Microsoft Foundation Classes (MFC) included with: - Microsoft Visual C++, 32-bit Editions, versions 4.0, 4.1, 4.2, 5.0

SUMMARY

The documentation for the CDaoWorkspace::CompactDatabase function does not specify the format of the password parameter. The password must be in the following format: ";PWD=password". If the password is not in the correct format, you may see the following error:

   Can't find installable ISAM

MORE INFORMATION

The documentation for the CDaoWorkspace::CompactDatabase function gives the following information about compacting a password-protected database:

static void PASCAL CompactDatabase( LPCTSTR lpszSrcName, LPCTSTR

    lpszDestName, LPCTSTR lpszLocale, int nOptions, LPCTSTR lpszPassword );

lpszPassword   A password, used when you want to compact a
               password-protected database. Note that if you use the
               version of CompactDatabase that takes a password, you must
               supply all parameters.

Syntax DBEngine.CompactDatabase olddb, newdb [, locale [, options

    [, ;pwd=password]]]

Part           Description
password       An optional string argument containing a password, if the
               database is password protected. The string “;pwd=“ must
               precede the actual password.

Sample Code

   /* Compile options needed: none
   */

   /* The following code will compress the database C:\DB1.MDB, which has
    * a password of "MyPassword"
   */

    try
    {
        CDaoWorkspace::CompactDatabase( _T( "C:\\DB1.MDB" ),
            _T( "C:\\DB2.MDB" ), dbLangGeneral, dbVersion30,
            _T( ";PWD=MyPassword" ) );
    }
    catch( CDaoException* e )
    {
        AfxMessageBox( e->m_pErrorInfo->m_strDescription );
        e->Delete();
    }

REFERENCES

Visual C++ Books Online: CDaoWorkspace::CompactDatabase Visual C++ Books Online: DBEngine.CompactDatabase