Compact & Repair Access Database.

How can I compact & Repair Access Database from visual basic?

DAO can do this. But I want to do it with ADO or Access Automation by VB. My database is password protected (database Password)

Can you help me?

http://www.planet-source-code.com/xq...s/ShowCode.htm

Thanks A lot. It helped me. I also tried with access automation. (Reference to access 9.0 object library). It has a method to compact database. but I failed to use it with database password.

Thank you again.