Results 1 to 11 of 11
  1. #1
    2 Star Lounger
    Join Date
    Jun 2004
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MDE Error (2003)

    I am trying to make an MDE file of a database and I am getting an error message that says:

    This error is usually associated with compiling a large database into an MDE file.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MDE Error (2003)

    How many database objects (tables, queries, forms, reports, macros, modules) does your database contain?

  3. #3
    2 Star Lounger
    Join Date
    Jun 2004
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MDE Error (2003)

    There are:

    11 tables
    21 qeries
    16 forms
    9 reports
    1 macro
    3 modules

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MDE Error (2003)

    That doesn't look like a lot. Try the following:
    - Create a new blank database in Access 2002/2003 format.
    - Import all objects from your database into the new one.
    - Set the Startup options the way you want (in particular, make sure you specify a startup form)
    - If your database needed non-standard references in VBA, set them in the new database too.
    - Select Debug | Compile <project> in the Visual Basic Editor, to check the code.
    - Try to create an MDE from the new database.

  5. #5
    2 Star Lounger
    Join Date
    Jun 2004
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MDE Error (2003)

    That worked. Thanks again

  6. #6
    2 Star Lounger
    Join Date
    May 2005
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MDE Error (2003)

    I am getting the same error messages. Unfortunately, importing into a new database has not solved the problem. I too have a limited number of tables and forms. Where to next?
    nebbia

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MDE Error (2003)

    Is your database in Access 2002/2003 format? You cannot create an MDE database from a database in Access 2000 format if you're using Access 2003.

  8. #8
    2 Star Lounger
    Join Date
    May 2005
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MDE Error (2003)

    Originally it was a 2000 db. It was converted several months ago to a 2003 format without any outward effects.

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MDE Error (2003)

    Do you get an error message if you select Debug | Compile <projectname> in the Visual Basic Editor?

  10. #10
    2 Star Lounger
    Join Date
    May 2005
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MDE Error (2003)

    Yes I did. The message read that ' only comments may appear after end sub, end function or end property" There appears to have been a double 'end sub' entry. I removed one of these, recompiled without difficulty and then created the mde file.

    As always-thanks

    nebbia

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: MDE Error (2003)

    Mostly for others reading this thread:
    You cannot create an MDE as long as there are syntax errors in the VBA code. So before creating an MDE file from your database, you should always try to compile the VBA code in the database using Debug | Compile <project name> in the Visual Basic Editor. If you get an error message, locate and correct the error. Repeat this until you can compile the code without error messages.

    (Another tip: you should take care that no unhandled errors can occur. In an MDE, you cannot debug the code, so an unhandled error is fatal. Every major routine should have an On Error Goto ... line and an error handling section.)

Posting Permissions

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