Cannot create mde

[SusanV]

Good morning all,

Access 2000, split db. After making some modifications to the front-end mdb,
everything compiled fine, did a compact & repair, but could not make mde
file (that's pretty much what the error said too - tres helpful - NOT!). Got
around this by importing all to a new db, then had no trouble making mde.

For future reference to avoid a repeat, what could cause this?

TIA,

SusanV

 

[Allen Browne]

Susan, there's a good chance that decompiling would have fixed this for you.

An Access mdb contains 2 copies of the code:
- the text version (what you edit);
- the compiled version (what actually executes.)

These two can get out of sync. A decompile instructs Access to discard the
compiled version. It then creates it again from the text version, and so the
problem is gone. (This problem is quite common if you are opening the MDB in
different versions of Access, since each version uses a different compiled
binary.)

To decompile, make a copy of the database, and enter something like this at
the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

If that does not do the trick, this link contains other suggestions:
http://www.access.qbuilt.com/html/conversion.html#CannotMakeMDE

 

[SusanV]

Thanks Allen, I hadn't thought of decompiling it - although I've done that
in the past for other issues. Time was a factor, and the quickest thing I
could think of at the time was to import to new db, which worked at least!

Thanks for the info,

SusanV

 

[SusanV]

Additionally, I read the checklist on the page you linked, and none of those
scenarios applied. Bookmarked the page though - thanks!