I'm a DAO guy, but I'm trying to switch over to ADO. One of the stumbling blocks is that I need to be able to:

1) Compact a database; no database password, no encryption
2) Compact a password protected database
3) Encrypt a password protected database

In DAO, steps 2 & 3 are wrapped up into a single call.

Also, for the bonus round, in ADO how do you:

A) Set a database password
B) Change the database password
C) Unset the database password

Thanks much.