regarding making a mde for a large application

[ram]

I have a application which has 14 linked tables, 24 forms ,46 reports
,1 macro and about 50 queries.
the error while converting this application to MDE is ...
Microsoft access is unable to create a MDE database because
"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."

how can make a mde for this application??so that functionality remains
the same

please tell a solution for this?? as soon as possible

 

[Albert D.Kallal]

That error message you get is somewhat misleading.

While looking at some code, do a debug->compile.

The above should show you any compile errors you have. Fix them..and
continue to repeat the debug-compile until you find no errors when you
compile. You then will be able to build your mde....

As a general rule, I ALWAYS compile right after making code changes. So,
then, when it comes to creating the mde, then I never have a problem.

You are no where close to approaching any kinds of limits here...so, likely
your problem is code errors that been in there all the along!!! (this is one
great reason why you distribute a mde!!!...it ensures you don't have a bunch
of compile errors!!).

Best to make a habit of doing a debug-compile right before you save your
code (both of which I alwasy do...even for very minor changes...