Welcome to SPN

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

Sign Up Now!

Can't convert to an MDE file

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

Tags:
  1. Dan

    Dan
    Expand Collapse
    Guest

    Hi -

    I'm getting an error when I try to convert an Access 2003 version database
    to an MDE file (see error pasted below). It's not a very big application -
    only about 20 forms, 9 code modules, 15 query objects, and 10 linked tables.
    What can I do to be able to save this to an MDE?

    Thanks a lot for any help!

    Dan

    ---------------------------------------
    "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."
     
  2. Loading...


  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    check if it compiles & that the Database Format is 2003

    Pieter

    "Dan" <Dan@discussions.microsoft.com> wrote in message
    news:3927D60D-EC81-474D-B430-84B59F152E1B@microsoft.com...
    > Hi -
    >
    > I'm getting an error when I try to convert an Access 2003 version database
    > to an MDE file (see error pasted below). It's not a very big
    > application -
    > only about 20 forms, 9 code modules, 15 query objects, and 10 linked
    > tables.
    > What can I do to be able to save this to an MDE?
    >
    > Thanks a lot for any help!
    >
    > Dan
    >
    > ---------------------------------------
    > "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."
    >




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4079 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  4. Dan

    Dan
    Expand Collapse
    Guest

    It compiles fine and it says "(Access 2002 - 2003 file format)" at the top of
    the database window. I notice when I delete unused objects to clean up the
    database, it converts ok to an MDE. I still don't know why it doesn't do it
    correctly in the first place since it's not a very big app.


    Thanks a lot!

    Dan



    "Pieter Wijnen" wrote:

    > check if it compiles & that the Database Format is 2003
    >
    > Pieter
    >
    > "Dan" <Dan@discussions.microsoft.com> wrote in message
    > news:3927D60D-EC81-474D-B430-84B59F152E1B@microsoft.com...
    > > Hi -
    > >
    > > I'm getting an error when I try to convert an Access 2003 version database
    > > to an MDE file (see error pasted below). It's not a very big
    > > application -
    > > only about 20 forms, 9 code modules, 15 query objects, and 10 linked
    > > tables.
    > > What can I do to be able to save this to an MDE?
    > >
    > > Thanks a lot for any help!
    > >
    > > Dan
    > >
    > > ---------------------------------------
    > > "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."
    > >

    >
    >
    >
    > --
    > ----------------------------------------
    > I am using the free version of SPAMfighter for private users.
    > It has removed 4079 spam emails to date.
    > Paying users do not have this message in their emails.
    > Get the free SPAMfighter here: http://www.spamfighter.com/len
    >
    >
    >
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Always Do a compact & Decompile before making a mde - ie get rid of the crap

    Pieter

    "Dan" <Dan@discussions.microsoft.com> wrote in message
    news:4F15338A-BA43-4FF9-B4B8-39BEC2118707@microsoft.com...
    > It compiles fine and it says "(Access 2002 - 2003 file format)" at the top
    > of
    > the database window. I notice when I delete unused objects to clean up
    > the
    > database, it converts ok to an MDE. I still don't know why it doesn't do
    > it
    > correctly in the first place since it's not a very big app.
    >
    >
    > Thanks a lot!
    >
    > Dan
    >
    >
    >
    > "Pieter Wijnen" wrote:
    >
    >> check if it compiles & that the Database Format is 2003
    >>
    >> Pieter
    >>
    >> "Dan" <Dan@discussions.microsoft.com> wrote in message
    >> news:3927D60D-EC81-474D-B430-84B59F152E1B@microsoft.com...
    >> > Hi -
    >> >
    >> > I'm getting an error when I try to convert an Access 2003 version
    >> > database
    >> > to an MDE file (see error pasted below). It's not a very big
    >> > application -
    >> > only about 20 forms, 9 code modules, 15 query objects, and 10 linked
    >> > tables.
    >> > What can I do to be able to save this to an MDE?
    >> >
    >> > Thanks a lot for any help!
    >> >
    >> > Dan
    >> >
    >> > ---------------------------------------
    >> > "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."
    >> >

    >>
    >>
    >>
    >> --
    >> ----------------------------------------
    >> I am using the free version of SPAMfighter for private users.
    >> It has removed 4079 spam emails to date.
    >> Paying users do not have this message in their emails.
    >> Get the free SPAMfighter here: http://www.spamfighter.com/len
    >>
    >>
    >>
     
  6. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Always Do a compact & Decompile before making a mde - ie get rid of the crap

    Pieter

    "Dan" <Dan@discussions.microsoft.com> wrote in message
    news:4F15338A-BA43-4FF9-B4B8-39BEC2118707@microsoft.com...
    > It compiles fine and it says "(Access 2002 - 2003 file format)" at the top
    > of
    > the database window. I notice when I delete unused objects to clean up
    > the
    > database, it converts ok to an MDE. I still don't know why it doesn't do
    > it
    > correctly in the first place since it's not a very big app.
    >
    >
    > Thanks a lot!
    >
    > Dan
    >
    >
    >
    > "Pieter Wijnen" wrote:
    >
    >> check if it compiles & that the Database Format is 2003
    >>
    >> Pieter
    >>
    >> "Dan" <Dan@discussions.microsoft.com> wrote in message
    >> news:3927D60D-EC81-474D-B430-84B59F152E1B@microsoft.com...
    >> > Hi -
    >> >
    >> > I'm getting an error when I try to convert an Access 2003 version
    >> > database
    >> > to an MDE file (see error pasted below). It's not a very big
    >> > application -
    >> > only about 20 forms, 9 code modules, 15 query objects, and 10 linked
    >> > tables.
    >> > What can I do to be able to save this to an MDE?
    >> >
    >> > Thanks a lot for any help!
    >> >
    >> > Dan
    >> >
    >> > ---------------------------------------
    >> > "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."
    >> >

    >>
    >>
    >>
    >> --
    >> ----------------------------------------
    >> I am using the free version of SPAMfighter for private users.
    >> It has removed 4079 spam emails to date.
    >> Paying users do not have this message in their emails.
    >> Get the free SPAMfighter here: http://www.spamfighter.com/len
    >>
    >>
    >>




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4079 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     

Share This Page