Results 1 to 3 of 3

Thread: MDE File (2k)

  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MDE File (2k)

    I have to deploy a new version of my database this week, and I'm going to use an MDE file this time (as opposed to an editable front end file). Are there any drawbacks to using an MDE file? It seems to be a lot more secure since users can't go into the design of anything, but I'm not familiar with using them. Just wondering if I should be expecting any problems <img src=/S/eyeout.gif border=0 alt=eyeout width=15 height=15>
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: MDE File (2k)

    Make sure that you have error handling in all your VBA code, and that you have tested the MDB version on all configurations. One you have created the MDE, unhandled errors are a serious problem, as are missing references.

    Also make sure that you keep a copy of the MDB, for if you ever need to modify a form, report or module, you will have to do it in the MDB, then create a new MDE from it.

    An MDE is more secure than an MDB, but in the thread starting at <post#=417229>post 417229</post#>, <!profile=ashrafk>ashrafk<!/profile> showed how to break into an MDE. The average user won't find out about it, but you should know about it.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MDE File (2k)

    wow... im going to assume none of my users will figure that one out. very interesting though. thanks for the info Hans.
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •