Depends on how the password was implemented.
Depends on the type (version) of the database
There are utilities for accessing VBA Code in the case of forgotten
VBA passwords,
If the file is an MDE, then it will be a lot more difficult.
If the file is workgroup based security, then there are also utilities
to work around this as well.
If it is custom implementation of a password then the best bet is to
look at the VBA Code