Unable to create MDE File

[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

 

[Douglas J. Steele]

See whether there's anything in the "Can't make an MDE!" checklist at
http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE that helps.

 

[Tony Toews [MVP]]

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.

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

Tony

 

[Tony Toews [MVP]]

Misleading error messages from MS Access! I'm shocked, I tell you, shocked!

;0)>

Hehehe

Tony