MDB V. MDE

[Guest]

Just to make sure that I understand this correctly there is no performance
advantage to mbE over mdB, it is simply a matter of protecting code??

Thanks.

Rick

 

[Rick Brandt]

Just to make sure that I understand this correctly there is no
performance advantage to mbE over mdB, it is simply a matter of
protecting code??

Thanks.

Rick

It depends. If the MDB is fully compiled then there should be no difference,
but MDBs can become uncompiled in which case the MDE will be faster. The
typical symptom is that you open a form that (for some reason) is not fully
compiled. The first time you open it will be slower because the code is being
compiled as you do so. Subsequent openings of the same form are then noticably
faster. This does not happen with an MDE.

 

[Guest]

That is how I thought that it worked, but wanted to make sure. Thanks so
much, I appreciate that you took the time to clear this up for me. Saved me
alot of time and likely un needed effort!

Rick