It's the usual story, Access 2000 file created by former employee who protected the VBA code with a password. Now, some time later, the VBA code needs to be changed and we're unable to extract the password from the former employee.
Searching online gives dozens of tools claiming to recover VBA passwords, but they have a wiff of Trojan about them.
What success have you had with recovering a VBA password? Recommend any tools? Know of any free tools?
I was in the same situation a few years ago - actually I forgot the password I used!!
Apparently VBA passwords are very easy to retrieve / reset. Something like resetting a few bytes. But I didn't have the time or inclination to write my own tool.
And yeah - it was daunting to search for a tool.
I found these guys and it did the trick - no spyware and they are still around...
(I actually only used the trial - which only gives you the first three chars but it was enough to remind me what password I used.)
http://www.elcomsoft.com/avpr.html
Anyways good luck...