speeding up the performance of a split database

[Tony Toews]

It does speed things up a bit. Computers are so fast today, that often it is
not much of a issue. However, the mde is smaller (no source code), the mde
cannot be modified by end users, and a mde is ALWAYS in a compiled mode.
Often, with a mdb, it can become un-compiled for many reasons. When this
happens, then the speed difference is noticeable, and even some bloating of
the FE can occur.

FWIW an MDE bloats slightly too. After several months some MDEs had
bloated by about 10% or so. Very likely query plan updating was part
of the reason.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Paul James]

Thanks for the info on MDE files, Tony. I've never used them before, so I'm
trying to find out what I need to know before I try using them.