Steve Erbach
erbachs at gmail.com
Mon Mar 16 08:52:28 CDT 2009
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