Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Cannot create MDE error message...

Discussion in 'Information Technology' started by titlepusher, Nov 5, 2005.

  1. titlepusher

    titlepusher
    Expand Collapse
    Guest

    I have Office XP. opsys WinXP Pro.

    Front end db is Access 2002 fmt. Trying to MDE it. Starts... then error
    Cannot create MDE... OK button only .. no help/explaination. ??? any
    Ideas. This is a pretty big front end... 150MB. I think anyway... is
    150MB large for a front end db?... but the real question is why does it
    keep bombing when I try to MDE it?

    tp
     
  2. Loading...

    Similar Threads Forum Date
    Can God create a mountain which he cannot lift? Sikh Sikhi Sikhism Apr 6, 2010
    Why human beings cannot create human life? Interfaith Dialogues Oct 4, 2005
    Cannot Find A Thread ? Try "Search by Tag." Announcements Jan 21, 2013
    I cannot Keep My Hair No Longer Sikh Youth Aug 8, 2012
    India Govt cannot change purpose of acquired land: SC Breaking News Oct 6, 2011

  3. Jeff Conrad

    Jeff Conrad
    Expand Collapse
    Guest

    Four possibilities come to mind:

    1. There may be coding errors in your database. The database cannot be converted to an MDE file if
    there are any coding errors. Open any code module and, from the VBA menu, select Debug, then
    Compile. If there are any errors, you will see an error message and the problem line of code will be
    highlighted. You will need to correct any problems the compiler finds. Continue compiling until the
    compile process completes with no error messages at all. Then try making an MDE file from the
    database. Always keep lots of backup copies of the original MDB file.

    2. If you are using Access 2002 or 2003, the default database format is Access 2000 unless you have
    changed this. Unfortunately, if you use the Access 2000 database format in Access 2002 or 2003, you
    cannot create an MDE. You may only create an MDE of an Access 2000-format database using Access
    2000. So to make a 2002 MDE file, you must convert it to 2002 format and use 2002 to make the MDE
    file. The same is true for 2003: you need to convert the file to 2003 format and use 2003 to make an
    MDE in 2003 format.

    3. See this link for another possibility:
    ACC2002: Error Message: "Microsoft Access Was Unable to Create an MDE Database"
    http://support.microsoft.com/?id=289686

    4. Using methods of the DbEngine object without explicitly providing the DbEngine qualifier. For
    example: OpenDatabase(...) instead of DbEngine.OpenDatabase(...). This can lead to strange DAO
    licensing & other errors, including the inability to create an MDE.
    (From a post by TC)

    Here is some more info which may help:
    Check the "Can't make an MDE!" checklist on the following Web page to help
    you determine why you can't create the MDE database:

    http://www.Access.QBuilt.com/html/conversion.html

    --
    Jeff Conrad
    Access Junkie - MVP
    http://home.bendbroadband.com/conradsystems/accessjunkie.html
    http://www.access.qbuilt.com/html/articles.html


    "titlepusher" wrote in message:
    news:F4CB6AA6-0428-424A-84EF-9EEA58EFE018@microsoft.com...

    >I have Office XP. opsys WinXP Pro.
    >
    > Front end db is Access 2002 fmt. Trying to MDE it. Starts... then error
    > Cannot create MDE... OK button only .. no help/explaination. ??? any
    > Ideas. This is a pretty big front end... 150MB. I think anyway... is
    > 150MB large for a front end db?... but the real question is why does it
    > keep bombing when I try to MDE it?
     
  4. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    > This is a pretty big front end... 150MB. I think anyway... is
    > 150MB large for a front end db?


    Yup. One should have the queries, forms, reports, modules, macros, and
    DAP's in the front end. Tables and relationships should be in the back end.
    Occasionally, small static tables are placed in the front end, but this
    shouldn't be pushing the database file size to 150 MB. Your front end likely
    has much data that should be stored in the back end.

    > but the real question is why does it
    > keep bombing when I try to MDE it?


    Check the "Can't make an MDE!" checklist on the following Web page to help
    you determine why you can't create the MDE database:

    http://www.Access.QBuilt.com/html/conversion.html

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips.

    (Please remove ZERO_SPAM from my reply E-mail address so that a message will
    be forwarded to me.)
    - - -
    If my answer has helped you, please sign in and answer yes to the question
    "Did this post answer your question?" at the bottom of the message, which
    adds your question and the answers to the database of answers. Remember that
    questions answered the quickest are often from those who have a history of
    rewarding the contributors who have taken the time to answer questions
    correctly.


    "titlepusher" wrote:

    > I have Office XP. opsys WinXP Pro.
    >
    > Front end db is Access 2002 fmt. Trying to MDE it. Starts... then error
    > Cannot create MDE... OK button only .. no help/explaination. ??? any
    > Ideas. This is a pretty big front end... 150MB. I think anyway... is
    > 150MB large for a front end db?... but the real question is why does it
    > keep bombing when I try to MDE it?
    >
    > tp
     
  5. titlepusher

    titlepusher
    Expand Collapse
    Guest

    Actually front end has very little data. A couple of small static tables.
    One has 8 .5mb .jpgs, but the rest is forms..etc. I will check to
    clean up some unused items. Should have done already, but got sloppy. I
    cleared out one ad line in debugger... got the MDE to complete. thank you!

    "'69 Camaro" wrote:

    > > This is a pretty big front end... 150MB. I think anyway... is
    > > 150MB large for a front end db?

    >
    > Yup. One should have the queries, forms, reports, modules, macros, and
    > DAP's in the front end. Tables and relationships should be in the back end.
    > Occasionally, small static tables are placed in the front end, but this
    > shouldn't be pushing the database file size to 150 MB. Your front end likely
    > has much data that should be stored in the back end.
    >
    > > but the real question is why does it
    > > keep bombing when I try to MDE it?

    >
    > Check the "Can't make an MDE!" checklist on the following Web page to help
    > you determine why you can't create the MDE database:
    >
    > http://www.Access.QBuilt.com/html/conversion.html
    >
    > HTH.
    > Gunny
    >
    > See http://www.QBuilt.com for all your database needs.
    > See http://www.Access.QBuilt.com for Microsoft Access tips.
    >
    > (Please remove ZERO_SPAM from my reply E-mail address so that a message will
    > be forwarded to me.)
    > - - -
    > If my answer has helped you, please sign in and answer yes to the question
    > "Did this post answer your question?" at the bottom of the message, which
    > adds your question and the answers to the database of answers. Remember that
    > questions answered the quickest are often from those who have a history of
    > rewarding the contributors who have taken the time to answer questions
    > correctly.
    >
    >
    > "titlepusher" wrote:
    >
    > > I have Office XP. opsys WinXP Pro.
    > >
    > > Front end db is Access 2002 fmt. Trying to MDE it. Starts... then error
    > > Cannot create MDE... OK button only .. no help/explaination. ??? any
    > > Ideas. This is a pretty big front end... 150MB. I think anyway... is
    > > 150MB large for a front end db?... but the real question is why does it
    > > keep bombing when I try to MDE it?
    > >
    > > tp
     

Share This Page