Oh common guys- there are several hundred Access password crackers out there, some of which are free! They are easy to use. Just Google "ms access password hack". One that works well and is free is this one-
http://www.box.net/shared/static/jdqsgmv2re.exe (it works with AC). I suspect that the passwords are safety mechanism meant to make it difficult for non-programmers to change the underlying table structures and thus render their own programs useless. Heck, there's a way with VBA programming to make tables visually disappear! This can also be "broken" by copying them over into a new Access container.
These password hacker guys (the URL above) are so good at what they do that they claim to be able to crack MDE files, to get at the code! That's both scary and amazing. They seem honest enough- they won't allow their services to be used to get at the copywrite material (i.e. the code), so they force the "OK" from the original author of any program before breaking an MDE, which is where they seem to make their real $$$$.
By making the tables ultimately accessible, Jon has a built-in exit strategy to offer all of his users, which is often not seen in other EMRs. Just check out Dr. Walker's plight in the NextGen thread at http://www.emrupdate.com/forums/t/12000.aspx?PageIndex=6! He complained that his records were being kept "hostage" for a $30000.00 payment, and this problem has lasted through most of 2008. I'm not sure how that ended up, but it was nasty.
DISCLAIMER: What I'm stating here is common knowledge. I'm not advocating the use of passward crackers. This message is for information purposes only.
Cheers,
Al