Re: My ritual question for each new version of Access since 2000

Sounds like the only option that will work is to set a reference to the MDE
in your live project, and then wait until last user is out to replace that
MDE.

I haven't seen the problem you describe of not being able to modify the MDB
just because someone is in the MDE. I can imagine the possibility that if
you put the MDB and the MDE of the library in the same directory, presumably
having the same name other than MDB and MDE, since you can only have one LDB
you could have a problem. But the real problem there is putting both MDB
and MDE in the same production directory. One or the other, but not both,
ever.

And in development, since you have to be out of the main project to release
the MDE anyway, there shouldn't be a problem with modifying the MDB and then
creating the MDE.
.

Relevant Pages

  • Re: Lock / Unlock VBA project
    ... "Alex Dybenko" wrote: ... make MDE? ... library MDB - create ne mdb, import forms/modules from your app, which ... have to make MDE of it and add reference to library MDE in order to make MDE ...
    (microsoft.public.access.modulesdaovba)
  • Re: Converting Access 97 MDE to Access 2003
    ... what is the MDB front-end you are ... The mdb front end is of course the original mdb you had to make the mde. ... ms-access is the in the SAME VERSION as what you are developing under. ... a mde file is created by going tools->database utile. ...
    (microsoft.public.access.conversion)
  • Possible Fix for "Unable to create MDE" Error and "Unexpected Error 40230" in Access 2002
    ... compile it and create an MDE on the local disk. ... With each one I progressively deleted more and more objects in the mdb until ... Dev PC is WinXP SP1. ...
    (microsoft.public.access.conversion)
  • Re: 5 access 2000 users and 1 AccessXP user
    ... > Making the user an administrator on the local machine worked for the case ... > it to th PC (it is an mde file). ... The back end is on a server running win2K ... locate the front end mdb file on the ...
    (microsoft.public.access.conversion)
  • RE: Function name not found
    ... but shouldn't the MDB use the same references? ... something happen in the MDE compilation process that disallows the XP machine ... I have this startup methodology that provides a little more flexibility than ...
    (microsoft.public.access.modulesdaovba)