怎样用DAO给access数据库设置密码

通过CDaoDatabase类的DAODatabase接口可以设置Access数据库的密码，下面是代码

void SetDBPassword( LPCTSTR pDB, LPCTSTR pszOldPassword, LPCTSTR pszNewPassword )

{

CDaoDatabase db;

CString strConnect( _T( ";pwd=" ) );

// the database must be opened as exclusive

// to set a password

db.Open( pDB, TRUE, FALSE,

strConnect + pszOldPassword );

COleVariant NewPassword( pszNewPassword, VT_BSTRT ),

OldPassword( pszOldPassword, VT_BSTRT );

db.m_pDAODatabase->NewPassword( V_BSTR( &OldPassword ),

V_BSTR( &NewPassword ) );

db.Close();

}