Access Code Window Crash

[Andrew D'Alton]

Here's hoping someone else has encountered (and fixed)
this problem...

I am working on an Access 2000 database in Access 2002.
Everytime a form ties to access code be in design time or
run time, Access crashes (...has encountered a problem and
must close...)

I'm pretty much at my wits end; I've installed Office XP
SP2. The database used to do this less frequently, but
suddenly it does it all the time, to such an extent that I
can do nothing at all.

Kind Regards,
Andrew

 

[Henry]

First try compact and repair. Then open a new blank
AC2000 database and import everything from the currupt DB
to the new. This should help fix the curruption problem.

Be sure the new DB is AC2000 version, assuming you want
to keep the Db in AC2000 format.

Go to Microsoft KB and look up currupt database.
Hopefully you will find an answer there too.

Cheers,
Henry