Compiation Error in Form while prepping for MDE conversion

[Guest]

I am in the process of converting a number of Access 97 MDB FEs into MDEs. I
have been seeing compliation erros along the way. I have worked thru some of
these.

Normally, I go into the offending form, try to complie and let the debug
point out for me where the problem is. But there are times when the code
complies fine. But the MDE conversion still fails. What am I missing?

I am pretty well read up on 97 to 03 conversions, which is where all this is
heading to eventually.

Interestingly, some of the same databases that wont convert to MDEs, WILL
handle upgrade to 2003 just fine . . . .or appear to anyway.

Thanks for the help!

 

[Allen Browne]

First thing to try would be a decompile.

Decompile a copy of the database by entering something like this at the
command prompt while Access is not running. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
Then compact.

If that still fails, here some further things to check:
http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE