VB Editor not opening, causing err

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 16 Feb 2005 18:47 GMT

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

Reply to this Message

Joerg Ackermann - 16 Feb 2005 18:58 GMT

> I have an Access Database where it opens with no problem & will also
> open in Design mode with no problem.
[quoted text clipped - 3 lines]
>
> "Microsoft Access has encountered a problem & needs to close...."

...

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

Solve this the problem?

Acki

Reply to this Message

Jeff - 16 Feb 2005 19:25 GMT

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

> > I have an Access Database where it opens with no problem & will also
> > open in Design mode with no problem.
[quoted text clipped - 11 lines]
>
> Acki

Reply to this Message

Joerg Ackermann - 16 Feb 2005 19:35 GMT

> 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 ?

Try to import each object sepatately to find
corrupted ones.

Acki

Reply to this Message

Jeff - 16 Feb 2005 20:15 GMT

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

> > 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
[quoted text clipped - 7 lines]
>
> Acki

Reply to this Message

Joerg Ackermann - 16 Feb 2005 20:26 GMT

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

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

Reply to this Message

Jeff - 16 Feb 2005 21:05 GMT

Hi Joerg,

You rock !

Thank you that worked :-)

I appreciate your help.

Best regards,
Jeff

> > 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.
[quoted text clipped - 16 lines]
>
> Acki

Reply to this Message

Joerg Ackermann - 16 Feb 2005 21:35 GMT

> Thank you that worked :-)

Thank you for the reply.

Greetings from Germany
Acki

Reply to this Message