VB Editor not opening, causing err

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have an Access Database where it opens with no problem & will also open in
Design mode with no problem.

However, when it is open is Design mode & I try to open the VBE, the program
freezes for a minute & then the Access Msgbox comes up saying

"Microsoft Access has encountered a problem & needs to close...."
"Repair my open Database & restart MS Access..."

This typical msgbox which I am sure most are aware of comes up when there is
some problem with Access.

I tried repairing the database then & reopening it & still the same problem
persists.
- I also tried repairing it on my own
- I tried rebooting,
- I tried other Access Applications & I can go into VBE
from there.

Yet this one I cant.

Any ideas ?? Anyway to fix so I can go into VBE for this program ?

Any help would be greatly appreciated.

Thank you,
Jeff
 
Jeff said:
I have an Access Database where it opens with no problem & will also
open in Design mode with no problem.

However, when it is open is Design mode & I try to open the VBE, the
program freezes for a minute & then the Access Msgbox comes up saying

"Microsoft Access has encountered a problem & needs to close...."
Click to expand...
....

Open a new empty database and import all objects
from the db that has problems.

Solve this the problem?

Acki
 
Hi Joerg,

Thank u for the response but I tried that also, & the same things happend
with the new Database. When I try to Import the program freezes & then the
same msgbox appears, so it doesnt allow me to import.

Any other ideas ?

Still need help :-(

Thank you,
Jeff
 
Jeff said:
Thank u for the response but I tried that also, & the same things
happend with the new Database. When I try to Import the program
freezes & then the same msgbox appears, so it doesnt allow me to
import.

Any other ideas ?
Click to expand...

Try to import each object sepatately to find
corrupted ones.

Acki
 
Hi Joerg,

Thank u for the response again, but I dont think u understood. I can't
Import anything, not even a single Form or Module or anything. As soon as I
select File / Import & choose the original database then the err happens.

Any other ideas ?

Thank you,
Jeff
 
Jeff said:
Thank u for the response again, but I dont think u understood. I
can't Import anything, not even a single Form or Module or anything.
As soon as I select File / Import & choose the original database then
the err happens.
Click to expand...

Ok...

Try /DECOMPILE

-Make a backup of the DB!!
-create a link to the DB in that case:
"PathToMsAccessExe" "PathToMDB" /DECOMPILE
-DoubleClick the Link
-Try to open MDB and VBA-Editor

any success?

If yes, compile the Project

Acki
 
Back
Top