Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

mdb vs mde

Discussion in 'Information Technology' started by Tom, Jul 28, 2006.

Tags:
  1. Tom

    Tom
    Expand Collapse
    Guest

    Hi,

    I dont really know the differance between mdb and mde.
    Can anyone can explain that to me?

    Thanks,
    Tom
     
  2. Loading...

    Similar Threads Forum Date
    Ramdev deean yabhlleeahn..Nonsense of Ramdev PUNJABI Hard Talk Mar 12, 2014
    India Now, Ramdev backs Bluestar Memorial Breaking News Jul 6, 2012
    Hinduism Baba Ramdev Praises Guru Gobind Singh Interfaith Dialogues Apr 24, 2012
    India I Applaud Action Against Ramdev: Khushwant Singh Breaking News Jul 9, 2011
    India Ramdev Threatens Armed Rebellion, Govt Issues Stern Warning Breaking News Jun 8, 2011

  3. default105

    default105
    Expand Collapse
    Guest

    My take on it is this

    mdb is fully editable to the last bit, all your hard work in coding, macros,
    etc is available for others to steal. Which if you have hours in which you
    probably will, it is nice to have some of the rewards for your hard work.
    However, do remember open source files are great for others to learn off of
    also.

    mde will lock all code and ability to design. I would also recommend
    keeping your original mdb because a mde cannot be undone, once a mde always a
    mde.

    "Tom" wrote:

    > Hi,
    >
    > I dont really know the differance between mdb and mde.
    > Can anyone can explain that to me?
    >
    > Thanks,
    > Tom
    >
    >
    >
     
  4. Tom

    Tom
    Expand Collapse
    Guest

    Thanks.
    "default105" <default105@discussions.microsoft.com> wrote in message
    news:5FF72FBA-2F58-40DB-B24F-5830C562F662@microsoft.com...
    > My take on it is this
    >
    > mdb is fully editable to the last bit, all your hard work in coding,
    > macros,
    > etc is available for others to steal. Which if you have hours in which
    > you
    > probably will, it is nice to have some of the rewards for your hard work.
    > However, do remember open source files are great for others to learn off
    > of
    > also.
    >
    > mde will lock all code and ability to design. I would also recommend
    > keeping your original mdb because a mde cannot be undone, once a mde
    > always a
    > mde.
    >
    > "Tom" wrote:
    >
    >> Hi,
    >>
    >> I dont really know the differance between mdb and mde.
    >> Can anyone can explain that to me?
    >>
    >> Thanks,
    >> Tom
    >>
    >>
    >>
     
  5. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Tom,

    The .mde format is usually used when distributing an application to
    end-users. You cannot edit forms, reports or modules in .mde files. The
    canocial text (ie. human readable text) in your VBA code modules is stripped
    out of the .mde database. Only the "P" code remains, which is in a compiled
    form.

    A couple of advantages of .mde file format include:
    1.) The project cannot become decompiled
    2.) References tend to be more stable (ie. not as many issues with lost or
    missing references) and
    3.) Your users (and you too) cannot make changes to forms, reports and modules

    If you have any VBA code that requires saving changes to an object in design
    view, then the .mde format is not a suitable option.


    Tom Wickerath, Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "Tom" wrote:

    > Hi,
    >
    > I dont really know the differance between mdb and mde.
    > Can anyone can explain that to me?
    >
    > Thanks,
    > Tom
    >
    >
    >
     

Share This Page