Code break

[David]

Using Access 2002, when one of my forms opens, a VB code break is
initiated on the Form_Activate event. I did previously have a code
break at that line in the code, but I've since removed it, but the
break still happens now and I'm not sure how to make it stop.

Any suggestions?

Thanks.

 

[Allen Browne]

A Compact, Decompile, Compact sequence should fix it.

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database:
Tools | Database Utilities | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again.