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>