Mystery MDE compilation failure

[Sam Summers]

As usual i am fighting with the naturally engineered errors that plague microsoft software.

I have copied my database off the server to update it and make a few improvements. On re-installing it, it will not allow me to create an MDE.
It says it is corrupt!!!!!
I have read all the threads on here.
I have compiled it.
I have reset all the references.
I have compacted and repaired and then recompiled over and over and still it says it is corrupt.
This has to go back on the system even if i have to physically ram it on their with my bare hands.
I'm at my wits end with this.
No-one can use the system until i get it back on their again.

Thank you hugely in advance if you can help.

 

[KenHigg]

I would start opening forms and compile them one at a time to see if you can get a compile error...

 

[RuralGuy]

MVP Allen Browne has some suggestions on the subject at the following link:
Recovering from corruption

 

[ChrisO]

In the link as posted by RG, Allen Browne mentions the /decompile switch under the heading…

Symptom: "An error occurred while loading Form_FormName"

I doubt if we should consider Allen’s advice to only decompile under this circumstance. After many years of using the /decompile switch I now do it on a regular basis, after changes have been made to the FE, even if there is no problem.

More in info can be found at http://www.trigeminal.com/usenet/usenet004.asp?1033

But please note Michael Kaplan’s advice on “cottage cheese” and always make a backup before using the /decompile switch. I have never had to resort to a backup after a decompile but that doesn’t mean I won’t have to one day.

Hope that helps.

Regards,
Chris.

 

[Sam Summers]

Trouble is that these dont seem to apply. The database opens and runs as normal, but i need to install it on the system as an MDE and this is the only time that i am having a problem. It wont let me create an MDE saying that the database is already corrupt?
I have never had this before and everything compiles fine?

 

[Rich]

Have you tried importing everything into a new blank db?

 

[Sam Summers]

Would you believe it, That did it. Cheers Rich. Never really thought of that but might have tried it in the end.
Created a new blank Database imported everything.
Re-compiled and then created an MDE.
No problem.

Thanks everybody