VBE password nightmare 
Author Message
 VBE password nightmare

(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


(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.

Tue, 18 May 2004 03:32:40 GMT  
 [ 1 post ] 

 Relevant Pages 

1. VBE - Project.Protection.Password

2. VBE Editor Format -Access 2000-Font Problem!

3. CreateEventProc - How to hide VBE ?

4. Reducing indent of code in VBE

5. Retrieve currently selected text under VBE

6. Hide Access 2000 VBE

7. Line Numbers in VBE

8. VBE Add-in using VBA only?

9. Custom CommandBarButton in VBE

10. OutlookXP+VBE+VB6

11. Outlook/VBE/Re-Occuring Tasks

12. Outlook XP VBE


Powered by phpBB® Forum Software