MDE Dazed and Confused

[Kenln]

I know that when your DB has too many objects it cannot always be converted to an MDE file. But I have this happening at odd times. I have a DB with one linked table, one query, one sub-form, one main form and one module. NONE of which are all that large, quite small actually, very basic and simple.

I created it, saved it from Access 2000 to Access 2003 (no I didn't start that way, 2000 is the default), from there created and MDE. Perfect. I went to the original (Access 2000) changed one single line of code and guess what. Too many objects to make and MDE????????

This happens randomly and I don't know why. I want to deplay MDE but I can't count on it working from one minute to the next. I then created a new db and imported the objects and converted it to MDE and it worked fine until, guess what. I change ONE LINE OF CODE in the module. Now I can't create and MDE again.

Does anyone also have this happening?
Should I not rely on MDE being a useful tool?
If this is not uncommon is there a reason that I can learn and hopefully avoid doing?

Can someone help me with this one?

Thanks,

 

[Bodisathva]

first, the old faithful "remember to compact and repair"

second, if the code doesn't compile, you can't create an .MDE file, so drop into the VBA window and choose Debug-Compile. Chances are you'll find some hanging code somewhere.

 

[Kenln]

GREAT!

It worked on the first try.

I'm still learning...

 

[Kenln]

What is "Baka ni tsukeru kusuri ha nai"?

 

[KernelK]

There is no medicine that cures stupidity