Re: Can not make MDE while before I can

"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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Situmorang" <hfsitumo2001@xxxxxxxxx> wrote in message
news:048F5512-E5E2-4F91-A584-4AB8DE9FCEF1@xxxxxxxxxxxxxxxx
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 :Does 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
--
H. Frank Situmorang


"Allen Browne" wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frank Situmorang" <hfsitumo2001@xxxxxxxxx> wrote in message
news:8294C820-82B1-49EE-8A0B-CE3DA2F26E47@xxxxxxxxxxxxxxxx
>
> 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
> -- > H. Frank Situmorang



.

Relevant Pages

  • Re: MDE not possible ?
    ... First compile the MDB and make sure that there are no errors in the code ... before creating the MDE. ... Because of the methode used to compile the database a lot of references ... If your database is in Access 2000 file format (it should say on ...
    (microsoft.public.access.formscoding)
  • Re: Secure Payroll information w/o using Access Security
    ... compile, followed by Save). ... I thought the MDE would be a good approach, but I tried to create an MDE ... "This error is usually associated with compiling a large database into ... Create a startup form that is opened ...
    (microsoft.public.access.security)
  • Re: Secure Payroll information w/o using Access Security
    ... "Joan Wild" wrote: ... compile, followed by Save). ... I thought the MDE would be a good approach, but I tried to create an MDE ... "This error is usually associated with compiling a large database into ...
    (microsoft.public.access.security)
  • Re: Secure Payroll information w/o using Access Security
    ... Open your database and hit Ctrl-G. ... When you compile, it may find some errors in your code, which it will ... should then be able to make the MDE. ... Microsoft Access MVP ...
    (microsoft.public.access.security)
  • Re: Problems Making MDE.....
    ... > had trouble making an MDE database the problem has been ... > compile the database, ... > 2048 open TableIDs at one time. ...
    (microsoft.public.access.conversion)