Can not make MDE while before I can

[Frank Situmorang]

Hello,

I have read all the threads regarding MDE, and nothing matched my case.

Here is my problem,

I have tested before to make MDE while I am not quite finished in
developping my church membership database. At first I make for my own church,
then I rename for other churches in the same city for the same denomination.
With this renamed databased I have tested to make the "Hahomion" database (
name of my database) to MDE its OK, I can make it. And I have tested it to
compile a setup file using Innosetup" and it's OK

How when I finished my own church database, I renamed it again to be
"hahomion" and I have splitted it to have a backend. and now I tried to make
a Hahomion again but I can not make it again.

My question is how can I make it, what causes iit can not be made.
Thanks in advance

 

[Allen Browne]

Frank, there's a good reference list to refer to here:
http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE

 

[Frank Situmorang]

Allen, I am really upset on this making MDE, I have tried that webpage but
always failure.

This is what I have done:
1. I have tiried to convert mdb to 2000 format, then I installed Access 2000
then created MDE, but it can not
2. I have tried to convert my mdb to ver 2002, and and created MDE using my
XP office which has access ver 2002, but it was also failed.


So I appreciate your help because I am ready to maek a trial test in the
savedfile.com and I will let my churches try it, because this is for church
membership to be used by more than 100 SDA churches in Jakarta and
surrounding.

Anyway what is the meaning of oes the code compile? (This is the most
common reason for failing to create the MDE format.)

said in the webpage?

Fro your info there are few module and form that I imported and modified
according to my Indonesian langguage VBA ( some words change according to the
name of the control)

Do you think it mgiht be a prolbem?

Thanks very much

 

[Allen Browne]

"Does the code compile?"
That means: in the code menu, choose Compile on the Debug menu.
If it works, the compile option should be greyed out after that.

1. Always do a decompile after switching versions (esp. when going back.) To
do that, close Access, and enter something like this at the command prompt:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
Use the path to where msaccess.exe is found on your computer, and include
the quotes.

2. After the decompile compact, and hold down the Shift key (to bypass any
startup code.)

3. Then create a new (blank) MDB in Access 2000.
Turn off Name AutoCorrect.
Import everything: File | Get External.
(If you have already split, link the tables first, and then import the
queries, forms, reports and modules.)

4. Set minimal references.
Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.

5. Make sure the new database compiles.