Convert to MDE - Error

[Kelley]

Hi,

I have just spilt my MS Access 2000 db into front and back-
ends. Upon trying to convert the FE into mde format, I
recv the following error message - "Microsoft Access was
unable to create an MDE database". I have tried a number
of times and still no luck. All forms & tables are closed,
password has been supplied for code etc. I am stumped.

Any suggestions would be greatly appreciated.

Thanks.

 

[Albert D. Kallal]

Normally, you get that problem when you code has errors in it (in fact, part
of the idea to converting to a mde is good, since any compile errors will be
caught).

In other words, you wan to get rid of basic type-o, and code that can not
run correctly. (you just don't want that stuff in production code).

So, while looking at some code, select the "debug"->compile all

You want to make sure your code compiles. In fact, you MUST make sure your
code compiles before creating a mde. During normal development, you should
make a habit of doing this when you change your code.