Making mde file - forms keep causing problems

[tedmillerx]

I have a database in 2002 format that I need to make into an .mde file, but I seem to keep running into problems.

I get it to a point where making the .mde works fine, but I'm still making a lot of changes and updates. It seems like each time I make a change to the forms I have built, when I go in to make an .mde again I will either get an error message 'Microsoft Access was unable to create an MDE database', or the whole program just crashes.

Has anyone else had this problem?

 

[belovedcej]

Typically, the reason Access can't make an mde is that the code isn't compiled. Open a form in design view and view the code. Go to Debug/Compile to compile the database (if it is gray, that means it is in a compiled state and that isn't the problem.)

If the code is frequently "decompiling" for no apparent reason, there's a possibility that your front-end has some corruption. Strange crashes can mean the same thing. It happens often when there are frequent changes being made. Check out this web site for tips on preventing this:

http://allenbrowne.com/ser-25.html

You may want to google for similar websites - there's plenty out there on preventing corruption while developing.

 

[tedmillerx]

Thank you very much for the quick reply. I'm going to really focus on following your advice and the link you provided to allenbrowne.com. Lot of good info there.

 

[tedmillerx]

Thanks again for the info. Running the compile did the trick.

Last time this happened to me I actually went through the whole thing, figured out what forms were causing the problems, and sort of cobbled them back together by copying all the changes I'd made into an earlier working version and thus 'tricking' Access into thinking it was the same form. I wasn't looking forward to going through all that again! You're a lifesaver.

 

[belovedcej]

You're welcome! It's something I learned the hard way.