Unexpected Error 40230 using VB

[DH]

I have a Access .mdb application with its modules written in VB and protected with a password.

When I attempt to open a module to view the code to make changes I am prompted for the password as usual. I enter the password without the code appearing. I then go to view project explorer with VB, select the project, and an prompted for the password again. After entering the password and Access Error box appears stating that Access must be shut down.

At other times during this same sequence when trying to use VB within Access I receive the following error Unexpected Error [40230]

I am not sure what is causing this and I can't get to my code to modify it.

Has anyone run into this before or have any solutions?

Thanks,

DH

 

[markphsd]

If you can't get to your code you might try this:

Go to the code. Enter the password. Go to tools --> your database properties then select the tab protection. Unprotect your code.

Then try to import all of your objects into the new db. Hopefully that will work. If that works, you can do the next step.

Before you close the new db, make sure you compile your code. Don't compact and repair the new db. Close it, then open it and compact and repair. If you compact it before you close it you'll break it.

This is usually the second easiest solution if it's your file that is corrupt. The first easiest would just be to open your back up copy.

It's actually a documented answer for a different error, however i've found that it works well with different unexlicable corruptions.

Mark P.

Bleh

 

[DH]

Thanks, I'll give it a try

DH