[AccessD] Rather urgent: Access 2003 unable to create MDE

Steve Erbach erbachs at gmail.com
Mon Mar 16 08:52:28 CDT 2009


Dear Group,

I wonder if you could help me with a problem I can't say I've ever seen before.

I have a FE/BE database with 39 tables (mostly linked to the BE), 41
forms, 46 reports and subreports, 23 modules, and 117 queries.  The FE
MDB amounts to just under 27 MB in size, the BE is under 3 MB.

I'm using Access 2003 to create an MDE.  I get the error:

   Microsoft Office Access was unable to create an MDE database

There's a "Show Help >>" button that shows the following:

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

More information about this error message online.
~~~~~~~~~~~~~~~~~~~~

There is no additional on-line help.

What can I do to make an MDE file out of this app?

-- 
Regards,

Steve Erbach
Neenah, WI
http://www.NeenahPolitics.com
http://www.TheTownCrank.com




More information about the AccessD mailing list