Cannot edit module inside a form in Access 97

[Silvio Balzano]

We are running a homegrown Access 97 database application
that is quite large (17.8 MB, although we do have larger
ones). Anyway, when I go into design mode on a form and
attempt to modify any of the underlying code, the moment
I hit the return key, I get a Dr. Watson error. This is
the beginning of the dump file:

Application exception occurred:
App: msaccopt.dbg (pid=1676)
When: 6/8/2004 @ 12:13:35.250
Exception number: c0000005 (access violation)

Any help would be appreciated, since we can no longer
make changes to this system. Anyone who needs to see the
dump file, I will be happy to share.

Thanks,
Silvio

 

[Elwin]

try decompiling your code and recompiling

1) Use the 'decompile' switch to launch Access.
eg) Select Start / Run
Enter msaccess.exe /decompile
Click OK

2) Open your database
3) Close Access
4) Reopen Access normally (no switches)
5) Go to a code window and compile your code
6) Save
7) Repair the database
8) Compact the database