How to make the MDE file

[Danny]

Hi,

I try to use the database utilities to save the file to MDE but it return
error saying it cannot create the MDE file. What is the tips to solve this.
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.
More information about this error message online.

 

[Douglas J. Steele]

See whether the information in the "How to determine why Access is unable to
create an MDE database" at http://www.access.qbuilt.com/html/conversion.html
helps.

 

[Klatuu]

How many tables, queries, forms, reports,and macros do you have?
To hit this limit is very unusual.

I woud suggest you compile you VBA code. An application that has compile
errors cannot be converted to an mde.

Then do a compact and repairs and try to create your mde again.

 

[J.Alladien]

Hi,

I had the same problem with the exact same message, I did the following:
Click any form->CODE => DEBUG => COMPILE and then fix the compiling errors
that are going to be highlighted,after that I was able to make the mde
without problems!

Don't forget to make a backup first!

HTH