
Error compacting a password-protected Access database
Hi all,
I have an Access database with a password ABCDEFGH. In my Visual C++ 5
application, I have the following line:
CDaoWorkspace::CompactDatabase(_T("C:\\MyDB.mdb"), _T("C:\\Temp.mdb"),
dbLangGeneral, 0, _T("ABCDEFGH"));
This line throws an exception "Couldn't find installable Isam" (error
code 3170).
If I remove the password from my database, and do this:
CDaoWorkspace::CompactDatabase(_T("C:\\MyDB.mdb"), _T("C:\\Temp.mdb"),
dbLangGeneral, 0, _T(""));
it works fine.
Can anyone help me with this?
Thanks in advance...
-Eric Harmon