HELP When select VBA Editor Access shuts down!

[laavista]

This morning, when I clicked on the VBA Editor to bring up my procedures and
modules, I got a "Microsoft Office Access has encountered a problem and needs
to close..."

My tables, reports and forms all open OK.

I tried compacting/repairing.

Yesterday's backup does not work. Day before does, but if I use, I will
lose a lot of work. I got a lot accomplished yesterday.

Any ideas?

Your help would be GREATLY appreciated.

 

[Armen Stein]

This morning, when I clicked on the VBA Editor to bring up my procedures and
modules, I got a "Microsoft Office Access has encountered a problem and needs
to close..."

My tables, reports and forms all open OK.

I tried compacting/repairing.

Yesterday's backup does not work. Day before does, but if I use, I will
lose a lot of work. I got a lot accomplished yesterday.

Any ideas?

Your help would be GREATLY appreciated.

Some other things to try:

- reboot your PC if you haven't already

- use the /decompile command line switch
(http://www.mvps.org/access/bugs/bugs0008.htm)

- if that doesn't work, copy everything from your old database into a
new empty database

Armen Stein
Microsoft Access MVP
www.JStreetTech.com

 

[laavista]

THANK YOU!!!!!!!!! Copying everything into new database worked!

THANK YOU for taking the time to response to my question!!!!!

 

[Armen Stein]

THANK YOU!!!!!!!!! Copying everything into new database worked!

You're welcome, I'm glad it worked! That little trick can be handy
for many weird errors and database corruptions. It's always worth a
try.

Allen Browne has a nice list of database corruption recovery
techniques here:
http://allenbrowne.com/ser-47.html

Cheers,

Armen Stein
Microsoft Access MVP
www.JStreetTech.com