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

1) decompile ...gets rid of old table references in the p-code
2) create a new mdb and import everything into it before creating the mde
3) use Max's Eat Bloat utility to take everything to text and re-import it 
...I've found this to be the ultimate degarbageing tool.
...one of the above has always worked for me ...hth.
William

--------------------------------------------------
From: "Steve Erbach" <erbachs at gmail.com>
Sent: Monday, March 16, 2009 9:52 AM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
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
>