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!

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/co...#CannotMakeMDE

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"G-Man" <(E-Mail Removed)> wrote in message
news:0DC7E757-5B67-4283-82F1-(E-Mail Removed)...
>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!