Error on creating MDE file

[ashu.doc]

Hi my database application is around 4.8 MB size and only 10 forms and round about 15 tables. But when I am trying to create the MDE file from this application, it is giving this error message that access is unable to create MDE file becuase -


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.

Any solution please?

[pbaldy]

Does the database compile (Debug/Compile DatabaseName)? A db that has compile errors is the usual problem when you can't create an mde. Compile until it runs without errors and see what happens.