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

Kaup, Chester Chester_Kaup at kindermorgan.com
Mon Mar 16 09:00:27 CDT 2009


Check for any modules that will not compile. I had a database that would not make an MDE and that was the problem.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Erbach
Sent: Monday, March 16, 2009 8:52 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Rather urgent: Access 2003 unable to create MDE

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list