Access XP CRASH!! on opening VBA Editor Or Modules

L

Luke

Please Help!


I have written a lot of code for a database Ive been working on in a fully
up to date, legal version of Access XP. Unfortunately, Ive been stupid and
havent been creating backups.

THE PROBLEM;
When I try to open the VBA editor, trigger any code or view any module
within the project, access crashes with that terrible message...

" Microsoft Access has encountered a problem and needs to close. We are
sorry for the inconvenience."

This only happens with the one .mdb file. Ive tried exporting my forms and
modules to a new blank .mdb file. This just moved the problem to the new DB.

Is it possible to recover my code? What do you think is causing the problem?
How do I avoid the same problem in the future?


PLEASE HELP!

Luke
 
L

Luke

Hi Allen,

Wow! Can't thank you enough for your help. I was in a bit of trouble there
for a while and you've saved the day!

Cheers,

Luke.
 
A

Allen Browne

Great news!

No doubt you will be adjusting your backup routines now. During development
(when you are changing forms/reports/code), Access does corrupt fairly
often, whereas it is extremely reliable once it is developed and only the
data is being changed. So during development we make a copy of the mdb file
twice a day, so you never lose more than 1/2 a day's work.
 
R

Robert Zufall

what else can I do? Once "/decompile" worked for me, but now it does not help
anymore:
I have two win2k machines and one mdb-file: in normal daily use the mdb
works on both, but the vb-Editor I can only use on one computer. On the other
access2K crashes without further notice when I click try to view or edit the
code.
 
B

Bob

When you refer to the command prompt do you mean the old dos command prompt
or under run in Start? I did try both areas and was unsuccesful.
 
Top