Error Compiling Large Database into MDE file

[AccessDev]

I am getting this error message when I try to convert my Access 2003
application into an MDE file. What can I do?

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.

 

[AccessDev]

Well, I didn't figure out what the problem was, but I did figure out how to
fix it.
I decompiled the application file, then recompiled it and that fixed the
problem.
Here are the steps from the MSKB Article (814858) I found and thought I
would share in case anyone else runs into this problem:

Note Make a backup copy of the database before you start these steps.
1. On the taskbar, click start and then click Run.
2. Type <Microsoft_Access_Path>\msaccess.exe /decompile and then click OK.

Note <Microsoft_Access_Path> is the path of the folder where Access is
installed.
3. Open the original .mdb file or the original .adp file that you want to
save as the new MDE file or the new ADE file.
a. Press ALT+F11 to open the Visual Basic Editor.
b. On the Debug menu, click Compile <DatabaseName>.
c. On the File menu click Save <DatabaseName>, and then close the Visual
Basic Editor.

4. On the Tools menu, click Database Utilities and then click Make MDE File
or click Make ADE File.
5. In the Save MDE As dialog box or the Save ADE As dialog box, locate the
folder where you want to save the MDE file or the ADE file, type the file
name in the File name box, and then click Save.

 

[Ben]

This is magical !
Thanks for posting your own problemsolving !!! I had the same problem and I
now can continue considering distributing my DB...

Thanks again,
Ben