Hi guys...

I use VB code to compact and repair an Access Database, but i got a problem. I use
DBEngine.CompactDatabase strDbName, "Test2", , , ";pwd= " & strOldPwd ;but it show message that "invalid password" even i specify the correct password. Hope someone can help me to solve the problem.

Thanks in advance...

Pheap

I got the a solution now. If the Access Database has password we can not use this statment(DBEngine.CompactDatabase strDbName, "Test2", , , ";pwd= " & strOldPwd). so in order to use it we have to clear database password first and then we compact it and at last recover the old password. That's it.