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

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


>-----Original Message-----
>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
>.
>