Error When Attempting Edit of Form Code (Random)

[dsfcom]

Hello all. I'm having a problem with editing form code at times and cannot figure out why. I have a backup copy of my DB so I keep trying it but always seem to run across the same error eventually and then losing all of my changes having to start over again with the backup. The error seems to occur mostly when attempting to add a new event to an object using the code builder. Editing current events most times does not produce the error. So, using an unedited backup, I open the DB and open a form for editing. I then attempt editing an existing form event and it opens the code editor fine. I then close the code editor and attempt to add a new form event and it opens the code editor fine. I then close the code editor and attempt to edit an existing event for a control on the same form and the error occurs. I then attempt (again using the backup copy) to add a new event to the same control on the same form and the error occurs. The error is "Microsoft Access has encountered an error and needs to close." There is an option (check box) to compact and repair. Would there be a problem with the code editor? The DB is in 2000 format and I'm using 2003. I've worked in this configuration since 2003 came out and this is the first time having this problem. Thanks in advance for any/all inputs.

UPDATE: It seems that after the error and whether or not compact/repair is checked when "Don't Send" is clicked, none of the events for any form fire and errors are displayed that references are missing etc. What's the deal?

 

[gemma-the-husky]

occasionally you can get corruptions that are unrecoverable. I've had this and not been able to resolve it directly

i've gtot a (large) dbs in A2002, that just will NOT downgrade to A97 - a couple of forms end up with corruptions like you describe, that I just can get rid of.
---------------

try to copy the offending form/report swithin the database, but this probably will crash. Try to import a no-fault verison from an older dbs if you have one

try to delete the form/report, and recreate it (but this might fail also!)

if all these fail, the only other solution is to create a new dbs, and import everything other than the failing bits, THEN create them again.

 

[dsfcom]

Funny...after restarting my computer the problem went away.