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

Steve Erbach erbachs at gmail.com
Mon Mar 16 08:57:19 CDT 2009


Dear Group,

NO LONGER URGENT!  NEVER MIND!

It was a compile error of an undefined variable.  Sorry!

Regards,

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

On Mon, Mar 16, 2009 at 8:52 AM, Steve Erbach <erbachs at gmail.com> wrote:
> 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




More information about the AccessD mailing list