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