Problem with dbEncrypt

I'd like to encrypt files that are .mdb files which are created by my program using DAO. It seems that the only way is to use the CompactDatabase method. So I try to do :

m_pdaoDB->m_pWorkspace->CompactDatabase( strSrcFile,
strDestFile,
dbLangGeneral,
dbEncrypt,
strPassword);

where m_pdaoDB is a CDaoDatabase * object.

It doesn't work. I always get a message telling me that the ISAM driver hasn't been found. Do I have to do something special when I instanciate m_pdaoDB to let the application know that I'm not dealing with any ISAM or ODBC sources but only with Microsoft Jet databases ?

Thanks for help !

Hi,

the strPassword should be

";pwd=password"

where password is the password you want to insert in the new database (it's optional nway)

Marc