Microsoft Access has stopped working

[Leif]

I'm using Access 2010. I've been using it for about 3 months. Prior to that I was using Access 2003.

On one of my databases I'm getting the fatal error when I try to bring up a module in VBA.

"Microsoft Access has stopped working"

I tried doing a Compress and Repair. That appeared to work fine. However, when I try to go into VBA and still get the error.

I tried doing an Import Objects into a new database. However, I'm still getting this error.

The only thing I can think that caused the problem is that I used Access 2003 to make a change in one of my custom menus. This problem started after that.

Any ideas on a solution?

Thanks,
Leif

 

[CJ_London]

don't suppose you have a backup from just before you made the change in 2003? If so, revert to it, then make you changes again but this time for 2010

You could try to decompile the code. To create a quick tool - to do this do the following:

1. create a shortcut to the MSACCESS.EXE file in your program folder
2. right click on the shortcut and select properties
3. edit the target to include /decompile after the existing text - so it should look something like this - note the space after the last quotation mark

"C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" /decompile

4. click OK to save the change
5. change the name to something like 'Access Decompile'

To use the tool
1. Take a copy of your db as a backup to be safe
2. now click on the new shortcut - access will open, select your db from the list or select open to navigate to it - hold down the shift key to avoid starting any autoexecs etc
3. Once the db is open, the code will have been decompiled, compact it and close - you'll see the file is now much smaller
4. Now reopen, go to the vba editor and recompile

 

[Leif]

Thanks, that did the trick. And yes, I did have a backup.

I've used decompile before. Sometimes in 2003 a phantom break point in VBA would stop execution. However, I never had Access crash in 2003.