Unable to create MDE File

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I have a small database 5 tables, 5 forms, about 10 queries, few macros
ets... I repair and compacted my database and when I go to properties is
showing 552 KB. I am trying to create MDE file but I am getting error
message:

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.

Thanks
 
Greg said:
I have a small database 5 tables, 5 forms, about 10 queries, few macros
ets... I repair and compacted my database and when I go to properties is
showing 552 KB. I am trying to create MDE file but I am getting error
message:

This error is usually associated with compiling a large database into an MDE
file.
Click to expand...

That's a misleading message. Try compiling your code.

Tony
 
Back
Top