Can't convert to an MDE file

[Dan]

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

 

[Pieter Wijnen]

check if it compiles & that the Database Format is 2003

Pieter

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

--

 

[Dan]

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]

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

Pieter