Funny problem with database.

[HandSam]

My database takes around 3 minutes to compress and repair. It will make a slow computer to hang for that period. I thought that period is too long. Again there is this form that whenever I try to open it, it gives this error:
"the expression on Load you entered as the event property produced this error: user-defined type not defined".
the strange thing is that the form has no event on Load.
In addition, when that form opens, trying to move the mouse gives the mouse move error:
"the expression mouseMove you entered as the event property produced this error: user-defined type not defined".

Clicking on any button gives:
"the expression on Click you entered as the event property produced this error: user-defined type not defined".

Closing gives:
"the expression on unLoad you entered as the event property produced this error: user-defined type not defined".

this is the only form that behaves in this strange way. It had been working well earlier and I just do not know what happened, Please I need help

 

[Pat Hartman]

Sounds like the form is corrupted. Create a new empty database and import all the objects into it except the form. close the database and make a backup. Reopen the database and import the errant form. Fix all the references and startup options then close the database and reopen it.

As to the slowness to compact - is the database on a network drive? Is there sufficient free space? Is the database split? Is it the FE that you are trying to compact? With good design practices the FE shouldn't need compacting every time you close it. Are you experiencing bloat?