Unable to create an MDE database

[Matt Gauch]

When I try to compile my code utilities add-in
(HSCUtilities2002.MDA) to an MDE file, I get the following
informational error: Microsoft Access was unable to
create an MDE database

....even though I'm certain I've been able to compile this
same add-in to an MDE without problems in the past. What
could prevent Access from being able to save it as an MDE
file? NOTE: the only MDA referenced in
HSCUtilities2002.MDA is the utility.mda which ships with
Access - I removed that reference just to be safe, and
still receive the error...

 

[Douglas J. Steele]

Have you compiled the MDA? WIth any code module open, choose the Compile
option from the Debug menu, and Access will highlight the first error it
encounters. Correct it, and repeat until no errors are reported.

 

[John Vinson]

When I try to compile my code utilities add-in
(HSCUtilities2002.MDA) to an MDE file, I get the following
informational error: Microsoft Access was unable to
create an MDE database

...even though I'm certain I've been able to compile this
same add-in to an MDE without problems in the past. What
could prevent Access from being able to save it as an MDE
file? NOTE: the only MDA referenced in
HSCUtilities2002.MDA is the utility.mda which ships with
Access - I removed that reference just to be safe, and
still receive the error...

The two cases I've encountered which block mde creation are: any
compile error in the MDB or MDA (the code must be completely clean of
detected errors; it never will be clean of *undetected* errors
but...); and the database must be in 2002 format instead of the
default 2000 format.

 

[Matt Gauch]

Sure enough - that was the problem. I hadn't compiled it,
and there was a compile error, too. Thanks for the tip!

Matt Gauch
President/Principal Consultant
Humanized Systems Consulting, Ltd.