Converting Access 97 MDE to Access 2003

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: 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: 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)
Loading