Problems Making MDE.....

[Desperate Dana]

After spending a great deal of time developing a software package, I went to make a MDE, I received 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

To see if this was the problem, I remove all but a few tables, and forms and retried. Got the same message.

 

[Nikos Yannacopoulos]

Dana,

You do not say what the error message was.
It is true that failure to produce an .mde can be due to number of objects,
but it is not the only reason. Does the error message suggest that this is
indeed the problem, or are you just assuming?

Another common (actually, more common than the above) problem is coding
errors. To check if this is your case, open any module in design view, and
force a compilation: menu Debug > Compile (Project Name). If there is a
problem with your code it will be highlighted. Fix and repeat until no error
is found. Once all errors are fixed, you will be able to make your .mde if
the problem is indeed this.

HTH,
Nikos

After spending a great deal of time developing a software package, I went

to make a MDE, I received 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.

To see if this was the problem, I remove all but a few tables, and forms

and retried. Got the same message.

 

[Nate]

I have never made a large MDE database but when I have
had trouble making an MDE database the problem has been
in the VBA code. I removed modules and forms until it
compiled then to identify the problem modules.

-----Original Message-----
After spending a great deal of time developing a

software package, I went to make a MDE, I received 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.

To see if this was the problem, I remove all but a few

tables, and forms and retried. Got the same message.

 

[John]

Not that it's much consolation but I'm having exactly the
same problem. I hope someone can help

 

[GVaught]

Removing modules or forms is not necessary.

Just run the Debug | Compile all modules from the Code Editor window and the
problem will be highlighted, so you know exactly what code is the problem.