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

John W Colby jwcolby at gmail.com
Mon Mar 16 09:41:07 CDT 2009


Don't you love those oh so relevant error messages!

;)

John W. Colby
www.ColbyConsulting.com



Steve Erbach wrote:
> 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
>>     
>
>   
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
    </pre>
  </blockquote>
  <pre wrap=""><!---->
  </pre>
</blockquote>
</body>
</html>



More information about the AccessD mailing list