Re: speeding up the performance of a split database

From: Tony Toews (ttoews_at_telusplanet.net)
Date: 09/08/04 

Date: Tue, 07 Sep 2004 21:28:27 -0600

"Albert D. Kallal" <PleaseNOOOsPAMMkallal@msn.com> wrote:

>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

Relevant Pages

  • Re: VBA corrupt ?
    ... The aplication ... MDE is made in A2003. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.devtoolkits)
  • Re: 2 version of the Access in 1 PC
    ... >extensions mdb and mde. ... >mde always are assigned to Access 2000. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)
  • Re: MDE file Access 2003 on Access 2002
    ... Luca wrote: ... You must create the MDE in A2002 to use it in A2002. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.devtoolkits)
  • Re: speeding up the performance of a split database
    ... However, the mde is smaller, the mde ... >Often, with a mdb, it can become un-compiled for many reasons. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.formscoding)
  • Re: speeding up the performance of a split database
    ... However, the mde is smaller, the mde ... >Often, with a mdb, it can become un-compiled for many reasons. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)