Access2K .MDB will not convert to .MDE 1

[BillMc]

My Access 2000 database will not convert to a .mde. Anyone know why? BillMc

 

[Francescina]

Before the JET engine creates the MDE from the MDB it compiles the code of the modules (invisible for the user).
If an error occurs JET should tell you
"MDE could not be created BECAUSE THERE IS AN ERROR IN YOUR CODE. Please correct the error and try again. Thank you for using MS ACCESS."

Instead you get the non-informative message "MDE could not be created".

Just compile your code and you will immediatetely see what is going wrong.

Note: in some (rare) cases corrupt forms (their VB project to be precise) are responsible for the a.m. error. Then you need to create a new MDB and import all database objects into the new one except the damaged one.

 

[BillMc]

You are correct. I get the non-information message "MDE could not be created."

I do not know how to compile my code. Do you mean "compact and repair." I did that. Still will not create the MDE.

Thanks for your help. Bill

 

[edaj]

To compile your code go to CodeView and press
Debug\Compile Database

Hope this helps. Jade

 

[BillMc]

Jade,
I can't find CodeView. How to I get there. Thanks. Bill

 

[Francescina]

I suppose that you have a modules only in your forms, so open any form in Design mode and click on the "code" symbol.
Or just push ALT-F11.
In the VB Editor window choose the menu "Debug" and then "Compile".
Then you will see the VBA code on the screen, the error that causes your headache will be highlighted in yellow.
Fix the error and compile again.
You will only be able to create the MDE if the compiling works without complaints.

Good luck!

 

[BillMc]

I did exactly what you said. It worked! Thanks so much for taking the time to help me out here. I have just ordered Office XP Developer. I need to turn this database into an .exe and I just wanted to be sure it was OK before I did this. Thanks again. Bill