I know this post is very old but I found some helpful links to recover Access VBA password
Here is link to brilliant article, this article can help users to recover lost Access VBA password: http://www.trigeminal.com/code/DatabasePassword.bas
Or as darbid said above there are multiple...