(also posted on microsoft.public.access.security)
I'm going to have a heart attack.
I'm working with an Access 2000 database that has a lot of VBA code.
I tried to password protect the VBA code, and now NOTHING WORKS!!!!
Whenever I open the database, I get an illegal operation error message:
"MSACCESS caused an invalid page fault in KERNEL32.DLL"
When I bypass my startup form I can get to the database window and from
there to the Visual Basic Editor, but as soon as I try to look at the
project properties or any of my models I get the same error message, and
Access crashes.
I've scoured the Knowledge Base, I've updated to SR-1A, I've tried using
different computers, and nothing solves the problems. "Compact and repair"
doesn't fix it. Importing the modules to a new MDB file also doesn't work
(it won't import password protected modules). My database is toast.
Can anybody help? It would be hugely appreciated. Please email me at
Thanks!
(I should have backed up the database before trying to install a new
security feature, but it seemed so innocuous. Seemed like I should be able
to remove the password as easily as I added it.)
Info on the VBE password protect feature:
The Visual Basic Editor in Access 2000 has a feature where you can password
protect a project. My understanding is that this feature allows you to
prevent users from reading/copying your code, but it does not stop users
from running the code. In other words, people can use your database and
watch the magic work, but they can't check under the hood. Sounds like a
great way to prevent users from messing stuff up, in theory.