Access 2000 - Disappearing code

[June Macleod]

I have recently had a very worrying problem with my Access 2000 database -
code suddenly disappears.

In the last fortnight it has happened twice, once a Module vanished and the
second time a Form Module disappeared (although all the objects in the form
remained). Both these modules had existed for some time and no changes had
been made to them recently.

Has anyone else come across this? Any ideas what might be causing it? I am
fairly certain that I did not accidentally delete them and no one else has
access to them. The only thing different about this database from any of my
other databases is that I am using ADO instead of DAO though I can think of
no reason why this might make a difference.

Hoping someone can shed some light....

June

 

[George Hester]

Because when errors occur Access has a nasty habit of deleting things and continuing to operate as though that is what you want. You almost have to put an If err <> 0 Then after every statement in your code so if that is TRUE the sub quickly exists. And even that isn't sufficient. A better idea why...?