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

check if it compiles & that the Database Format is 2003

Pieter

"Dan" <(E-Mail Removed)> wrote in message
news:3927D60D-EC81-474D-B430-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:3927D60D-EC81-474D-B430-(E-Mail Removed)...
> > 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
>
>
>

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

Pieter

"Dan" <(E-Mail Removed)> wrote in message
news:4F15338A-BA43-4FF9-B4B8-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:3927D60D-EC81-474D-B430-(E-Mail Removed)...
>> > 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
>>
>>
>>

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

Pieter

"Dan" <(E-Mail Removed)> wrote in message
news:4F15338A-BA43-4FF9-B4B8-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:3927D60D-EC81-474D-B430-(E-Mail Removed)...
>> > 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