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.
> I am getting this error message when I try to convert my Access 2003
> application into an MDE file. What can I do?
[quoted text clipped - 10 lines]
> database has 500 forms, and each form's HasModule property is set to Yes, as
> many as 1,000 TableIDs are used.
Ben - 29 Dec 2005 13:46 GMT
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

Signature
Novice
> Well, I didn't figure out what the problem was, but I did figure out how to
> fix it.
[quoted text clipped - 36 lines]
> > database has 500 forms, and each form's HasModule property is set to Yes, as
> > many as 1,000 TableIDs are used.