Re: Converting Access 97 MDE to Access 2003

You have lost the original file.

You need the original file the MDE was created from.

Not the MDB with the data in it, a different MDB.

If you can't find the MDB that the MDE was created from, you're screwed.

(david)

<melickas@xxxxxxxxx> wrote in message
news:1132155831.256409.121170@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> We created an Access 97 database program (MDE) almost 5 years ago using
> VBA and used the Setup Wizard to create the installation floppies. We
> upgraded our computer to XP Pro & Access 2003.
>
> What is the step-by-step procedure to get this program working on our
> new computer?
>
> 1. So far, when we try to convert to Acc03 by opening the MDE, we
> receive the "Can't convert or enable MDE" error message.
>
> 2. If we open the MDB and try to convert, we get the "Missing or broken
> VBE reference to the file 'dao2535.tlb' "" error. We still have a copy
> of Access 97 on an old laptop, so we copied just the MDB file to the
> laptop and removed the reference to the DAO 2.x/3.x Compatibility
> Library and checked the Microsoft DAO 3.6 Object Library, recompiled
> all modules (there are only tables here), and copied this new MDB back
> to the new computer. We still received the error "can't convert or
> enable MDE".
>
> 3. We must have to make a new MDE with this"new" database?
>
> 4. Also, do we have to use Access 97 to remove the old library
> reference?
>
> Been awhile since we programmed, so details appreciated. Thank you!
>


.

Relevant Pages

  • Re: Correct Sequence?
    ... a reference to DAO by default. ... When you create a new mdb, ... Microsoft Access MVP ... Now try to create the MDE. ...
    (microsoft.public.access.security)
  • Re: creating external references
    ... The easiest way to implement this is with a referenced MDE. ... Then 'compile' it into an MDE and set a reference in your other ... deploy the frontends as MDBs (because an MDB will recompile against the new ... DLL, which means that all class GUIDs remain the same after a rebuild. ...
    (microsoft.public.access.modulesdaovba)
  • Re: expose class modules of a referenced mde
    ... Since I can't reference an .mdb from an .mde (which is what the final ... reference file and import the class objects as needed into the app. ...
    (comp.databases.ms-access)
  • Re: Function name not found
    ... certain Reference changes from version to version in MDBs, ... format (MDB is still fine) on the affected PC. ... Is there a way to check the pre-compiled MDE ... Looking at you Startup function, the first thing I see is a DFirst ...
    (microsoft.public.access.modulesdaovba)
  • 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)