Why my database is almost always locked?

This can happen if your app settings are balanced towards higher security, at the expense of convenience.

To unlock your database more quickly, please make sure that you have Remember Master Keys enabled, and Database Timeout set to sufficiently long value. The first one ensures that the master keys (password + key file) are kept for future re-use when you unlock the database. The second one erases stored keys after some time.