VBA events run fine in Access 2002 but not in 2000

[Bubba]

I have an Access database that is saved in the Access 2000
file format. There are various VBA modules and events.
When I open the database in Access 2002 everything runs
perfectly. However most of our users use Access 2000 and
if I open the database in Access 2000 sometimes the VBA
code does not execute. There is no error message but none
of the code works. For example if I have an event that
runs when you click a button you click it and it does
nothing. The strange thing is that sometimes when opening
the database in Access 2000 everything works fine but
other times nothing works. This sounds like a bug but I
haven't been able to find a patch that specifically
addresses this issue. Help!

 

[Peter R. Fletcher]

I have had occasional problems of this sort. One reasonably reliable
workaround that I found was (after making changes in 2002) to open the
Application in 2000 while pressing the Shift key (which bypasses any
startup code), open a Module or the code behind a Form, and
Debug|Compile the application. It would then work happily unless/until
further changes waer made in 2002.