Access 2003 Make MDE

[Zafar Salim]

Hi all!

I'm a first timer here...

While trying to make an MDE using access2003 this is the error i get :

" 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."

The mdb has 84 forms and works perfectly as an mdb in Access2003. Making MDE
in Access97&2000 has not been a problem.

Would appreciate if someone can help.

Thanks
Zafar

 

[Zafar Salim]

Further, when I used Custom Startup Wizard in Developer Extensions2003, to
create the MDE, this is the error I get :

"The MDE/ADE could not be created. Make sure that the original file exists
and that its VBA code will compile. Then try this again."

Which is original file? Is it a file other than the MDB?

How do I check if the VBA code will compile?

Would appreciate any kind of help

Thanks
Zafar