Results 1 to 15 of 15
  1. #1
    Join Date
    Jun 2004
    Posts
    23

    Exclamation Unanswered: Can't convert or enable an MDE File

    Hello, Can you assist?

    Here is the scoop -

    I was given an OLD program written in Access 97.
    This product is NO longer supported and needs to be modified.

    With the ORIGINAL instal program it has:

    Timer ( with a BLUE lock on the ICON ) 7138KB Microsoft Access MDE Dbase
    System ( Regular Icon ) 96KB Microsoft Access Workgroup info.

    I need to open this - Rename it and edit some tables and relationships.

    I am running Access 2k and need to figure out how to unlock it?

    How can I open it? How can I configure this UNSUPPORTED file to meet my needs?

    Thank you

    scott.badger@siemens.com

  2. #2
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    you can't convert or edit MDE databases. they are compiled MDB files and cannot be reversed to MDB.
    ghozy.

  3. #3
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    actually I just noticed you can edit MDE tables it is only the VBA code that you cant modify. if it is the autorun bothers you just press SHIFT while opening the database (and keep pressing till database opens). that should let you edit relationships and tables.
    Last edited by ghozy; 06-09-04 at 11:32.
    ghozy.

  4. #4
    Join Date
    Jun 2004
    Posts
    23

    Unhappy Trying

    When I slect the ICON on my desktop ( I moved the file there )
    I held SHIFT and Double Clicked:

    It poped up:
    Convert

    Open Database

    When I selected Convert: You can't convert or Enable MDE

    When I selected OPEN: You can't convert or Enable MDE

    So I still cannot edit?

  5. #5
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    it is obivous access trying to convert mde file from 97 to 2000 format but fails. because all the VBA code is compiled. I guess either you should find a copy of access 97 or you can import all data and releationship info into a new mdb file (but not code unfortunately). Thats all advice I can give.

    Maybe someone else here know a way to fix this problem?
    ghozy.

  6. #6
    Join Date
    Jun 2004
    Posts
    23

    How to Convert

    You said I could copy all the dat but NOT code? How do I do that?

  7. #7
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    create new mdb file
    open it
    choose from menu Files->Get External Data -> Import
    choose mde file you want to import from
    choose tables and queries you want to import
    click ok
    thats all.
    ghozy.

  8. #8
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    ^^^^^^^ or that ^^^^^^^^

    I'd hit it with ODBC if possible. I'm not sure how well that works with an mde... never tried it.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  9. #9
    Join Date
    Jun 2004
    Posts
    23

    Ok -

    But I could NOT get the Forms? and Reports or CODe? There has to be a way to get this data..?

  10. #10
    Join Date
    Jun 2004
    Posts
    23

    Odbc

    What is that? How would that HELP?

  11. #11
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    errrr.. you're not familiar with ODBC?? Do you have someone who knows db's you could get to help you?

    Anywho, no, you can't get the code, which in turn means you can't get the reports or forms whereas they are comprised entirely of said code). That's sort of the definition of an MDE, you can't touch the code.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  12. #12
    Join Date
    Jun 2004
    Posts
    23

    Ok Butt!!!

    I cannot even OPEN the dbase in my 2000 environment? Everytime I try to open it - It says that I cannot open or convert...So If I tried to open as a 2000 dbase - I get stuck. If I could open it...I could use the code written in the MDE-MDB converter and would be fine..

  13. #13
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521

    sorry

    I'm sorry I don't know any way to get forms, reports, macros or modules from a mde file. they are compiled. almost every book I read says save a copy of your mdb file somewhere safe, before converting it ti mde. because there is no way turning back.
    but still my word is not the last word on this subject. maybe there is a crazy developer out there found a way to reverse engineer mde files to mdb who knows?
    sorry.
    ghozy.

  14. #14
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    your only choice seems like find a access 97 owner and help you out or find a copy of access 97.
    ghozy.

  15. #15
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    I would almost be willing to bet there is a way to reverse a 97 MDE it would just be a matter of finding it on the net. Most older programs could be reversed. I mean older VB could be reversed so I dont see why an older database couldnt.

    You may have some loooooong google searching to do, to find someone or some program that can do that reverse engineering.

    I hope you get this done,
    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

Posting Permissions

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