CANNOT MAKE MDE FILE

[Glint]

Hi Guys,
I have an application split into back and front ends. I had always made the
front end an mde file to discourage some smart users from tampering with the
files. I recently made some necessary adjustments to the original front end
file, and when I tried to make an mde file out of it, I got an error message
that it could not be done: file too large, too many indices etc.
I really have to make the file mde. How do you suggest I go about it? Does
splitting the file into two smaller ones help in the long run? And if so,
what precautions should I observe?

 

[Allen Browne]

First thing to do would be to compact/repair the database.

In fact, it would be worth walking through these steps:
Recovery sequence
at:
http://allenbrowne.com/recover.html
That will address several issues that could prevent the creation of the MDE,
such as bad binary, bad indexes, bad references, uncompilable code, and so
on.

If you are still stuck after that, here is another check list to work
through:
Unable to create an MDE
at:
http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE

 

[Glint]

Thanks Allen.
No doubt I have missed something somewhere, but when I typed in:

"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile "c:\ECK
ADMIN\AreaAdminFE.mdb"

I got the error message: The system cannot find the path specified.

Also, I had checked Compact on close 0n the Tools right from onset, so I
assume the db always compacted on closing.

 

[Glint]

Allen, Thank you very much.
I continued the instructions and lo, there was an error when I tried to
decompile: I had deleted a textbox but still left its code somewhere!
Am grateful for your being there always.