Welcome to SPN

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

Sign Up Now!

Error when convert to MDE file

Discussion in 'Information Technology' started by Vensia, Jul 28, 2006.

  1. Vensia

    Vensia
    Expand Collapse
    Guest

    Dear all,

    What is the solution for below error ?

    This error is usually associated with compiling a large database into an
    MDE file. Due to the method used to compile the database, a
    considerable number of TableID references are created for each table.
    The Microsoft Jet database engine version 4.0 can only create a maximum
    of 2048 open TableIDs at one time. Exporting a database as an MDE
    potentially can exceed this limit if the database has a large number of
    objects (table, macro, form, report, etc).
    There is no accurate method to estimate the number of TableIDs the Jet
    database engine uses during the process of compiling a database as an
    MDE. However, each VBA module and each form uses one TableID, as a
    result, if the database has 500 forms, and each form's HasModule
    property is set to Yes, as many as 1,000 TableIDs are used.

    Thanks.
    Vensia
     
  2. Loading...


  3. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi, Vensia.

    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 and tutorials.
    http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    info.


    "Vensia" <vensia2000_nospam@yahoo.com> wrote in message
    news:%23oEwc9AoGHA.4172@TK2MSFTNGP03.phx.gbl...
    > Dear all,
    >
    > What is the solution for below error ?
    >
    > This error is usually associated with compiling a large database into an
    > MDE file. Due to the method used to compile the database, a
    > considerable number of TableID references are created for each table.
    > The Microsoft Jet database engine version 4.0 can only create a maximum
    > of 2048 open TableIDs at one time. Exporting a database as an MDE
    > potentially can exceed this limit if the database has a large number of
    > objects (table, macro, form, report, etc).
    > There is no accurate method to estimate the number of TableIDs the Jet
    > database engine uses during the process of compiling a database as an
    > MDE. However, each VBA module and each form uses one TableID, as a
    > result, if the database has 500 forms, and each form's HasModule
    > property is set to Yes, as many as 1,000 TableIDs are used.
    >
    > Thanks.
    > Vensia
    >
    >
     
  4. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    "Vensia" <vensia2000_nospam@yahoo.com> wrote:

    >This error is usually associated with compiling a large database into an
    >MDE file. Due to the method used to compile the database, a
    >considerable number of TableID references are created for each table.
    >The Microsoft Jet database engine version 4.0 can only create a maximum
    >of 2048 open TableIDs at one time. Exporting a database as an MDE
    >potentially can exceed this limit if the database has a large number of
    >objects (table, macro, form, report, etc).


    That is a *lot* of objects. Do you really needs that many objects?

    I'd suggest taking some functionality which is easy to separate out
    and put into it's own MDB.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  5. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi, Tony.

    >>This error is usually associated with compiling a large database into an
    >>MDE file. Due to the method used to compile the database, a
    >>considerable number of TableID references are created for each table.

    <SNIP>
    > That is a *lot* of objects. Do you really needs that many objects?


    For future reference, unlike earlier versions of Access which gave the
    extremely unhelpful error message "Microsoft Access was unable to create an
    MDE database" whenever conversion to an MDE database file failed, Access now
    provides a "Show Help >>" button to display further extremely unhelpful
    assistance whenever conversion to an MDE database file fails for any reason.

    Selecting the "Show Help >>" button reveals the "Help" message that Vensia
    copied verbatim into the post. If you bet money that the failure to convert
    the file to an MDE database file had nothing to do with excessive TableID's
    every time you saw this "Help" message, you'd win nearly 100% of your bets.

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
    info.


    "Tony Toews" <ttoews@telusplanet.net> wrote in message
    news:cuvoa21d700i29qd264eemu3b5q31fj9ie@4ax.com...
    > "Vensia" <vensia2000_nospam@yahoo.com> wrote:
    >
    >>This error is usually associated with compiling a large database into an
    >>MDE file. Due to the method used to compile the database, a
    >>considerable number of TableID references are created for each table.
    >>The Microsoft Jet database engine version 4.0 can only create a maximum
    >>of 2048 open TableIDs at one time. Exporting a database as an MDE
    >>potentially can exceed this limit if the database has a large number of
    >>objects (table, macro, form, report, etc).

    >
    > That is a *lot* of objects. Do you really needs that many objects?
    >
    > I'd suggest taking some functionality which is easy to separate out
    > and put into it's own MDB.
    >
    > Tony
    > --
    > Tony Toews, Microsoft Access MVP
    > Please respond only in the newsgroups so that others can
    > read the entire thread of messages.
    > Microsoft Access Links, Hints, Tips & Accounting Systems at
    > http://www.granite.ab.ca/accsmstr.htm
     

Share This Page