VBA editor won't open in 2007 (1 Viewer)

[evanscamman]

I'm running 2007 on Win 7. So far, I'd never had a problem with database corruption with this setup. But now, I can load the DB, open all forms with code that runs in the background - but I can't goto the VBA editor. If I press F11 then Access freezes.

Something must have gone corrupt - Does anybody know any tricks to correct this? (I have a backup, but it's a few days old...)

 

[HiTechCoach]

I'm running 2007 on Win 7. So far, I'd never had a problem with database corruption with this setup. But now, I can load the DB, open all forms with code that runs in the background - but I can't goto the VBA editor. If I press F11 then Access freezes.

Something must have gone corrupt - Does anybody know any tricks to correct this? (I have a backup, but it's a few days old...)

Make a backup before you do anything else.

There are a few things to try:

Make a backup!

Run Compact and repair

if that does not work:


Make a backup!

decompile the database usind the /decompile command line switch

if that does not work:

Make a backup!

1) Make a new blank database
2) Import all the objects from the old database.


Curious,
Is your database split?
Is the database opened by multiple users (shared)?

 

[evanscamman]

Thanks - I'll try all you say.
The DB is split, but it hasn't been deployed yet - I'm the only user. Back end and front end are sitting in the same folder on my home computer.

 

[evanscamman]

Compact didn't work but decompile did!
Got everything back!

Thank you,
Evan

 

[HiTechCoach]

Evan,

You're welcome.

Glad you were able to get it recovered.