Can make an MDE?!?!

[Guest]

I just split my db today. I decided to make my Front-Ends MDE's, but it's
not working. When I tried in on one of my unsplit back-ups from this
morning, it worked fine. Is there something about MDE'ing Front-Ends that I
don't know about? What's happening is, when I click on the tools menu option
"Make MDE..", I get the hourglass for a fraction of a second then Access
locks up and I have to "end program" to get out. I'm running 2002 on a LAN.
Any suggestions? Thx, Dj

 

[Guest]

First off, bring the FE mdb file to your hard drive where it belongs. Try
making an MDE there.

Second open the database file exclusively.

Third open the database and press Ctrl + G keys. Go to Debug, Compile your
database name. You can't create an MDE unless the database compiles properly.

 

[Guest]

Thanks Jerry,

Even though I have no idea what I did, I did what you suggested there with
the CntlG and it worked. If you wouldn't mind, could you take minute and
explain in "beginner's" terms what I did. Thanks!

 

[Guest]

Glad to hear it.

You compiled the code. Oversimplifying: Code can be in two states either
compiled or uncompiled. If you change some code, then Access runs the
uncompiled code and not the compiled version of it. Once you compile it,
Access throws away the uncompiled version of it. Uncompiled code runs slower
as basically Access needs to read all the text. Compiled code is streamlined
and ready to use. Also if you have both the compiled and uncompiled code in
the database, the database file is larger.

Now an MDE is nothing but compiled code. You can't change the code or create
new code. Therefore to create an MDE, the MDB file must be compiled first.

 

[Guest]

I think I got it. Thanks Jerry!

Glad to hear it.

You compiled the code. Oversimplifying: Code can be in two states either
compiled or uncompiled. If you change some code, then Access runs the
uncompiled code and not the compiled version of it. Once you compile it,
Access throws away the uncompiled version of it. Uncompiled code runs slower
as basically Access needs to read all the text. Compiled code is streamlined
and ready to use. Also if you have both the compiled and uncompiled code in
the database, the database file is larger.

Now an MDE is nothing but compiled code. You can't change the code or create
new code. Therefore to create an MDE, the MDB file must be compiled first.