Creating a MDE File

[Guest]

I am trying to create am MDE File but it gives me this error:

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.


I don't think that my database is really that large, it has 45 queries, 47
forms each with modules, 12 reports, 12 macros, and 5 modules. Is there
anything that I can do?

 

[Arvin Meyer [MVP]]

Is your database split? You should have no tables in the front-end (code
forms queries, reports, etc.) After splitting, you can try creating a new,
empty database and importing all the front-end objects into it. Do the same
for the back-end (data tables). The front-end should then compile into an
MDE, the back-end gets no benefit from doing so.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access