MDE creation problem

[Eric G]

Can someone please tell me some of the possible reasons
why Access 2000 isn't letting me create an .MDE file?
I get the following unhelpful error message with no
details:

"Unable to create MDE file"

Thanks! Eric

 

[Peter Doering]

Eric,

Can someone please tell me some of the possible reasons
why Access 2000 isn't letting me create an .MDE file?
I get the following unhelpful error message with no
details:

"Unable to create MDE file"

Try compile and save all modules. There may be compilation errors.

HTH - Peter

 

[Eric]

-----Original Message-----
Eric,



Try compile and save all modules. There may be compilation errors.

HTH - Peter

Thanks Peter. I'm not sure where to find the compile
feature. Eric

 

[Larry Linson]

Open any module, and in the module window, on the Menu, choose Debug, and
you will see your Compile options. They will differ between Access 97 and
later versions, but you'll find them in the same Debug menu item.

Larry Linson
Microsoft Access MVP

 

[Eric]

Thanks Larry.
I found the compile feature and it found an error.
It was weird because the 'event' wasn't activated, yet the
compile still complained.

I was told a while ago that if an event wasn't explicitly
mentioned in the properties box that underlying code
wouldn't run (After Update in my case).

Eric

 

[Eric]

Thanks very much for this tip.
I did happen to have a couple of modules which I was able
to use to get to the compile.
Eric

 

[Brendan Reynolds \(MVP\)]

The code won't run if it is never called, Eric, but it still needs to be
compiled. If you have code that isn't being used, it would be best to either
delete it (paste it into Notepad and save it as a text file if you think you
may use it elsewhere) or comment it out.

 

[Eric]

Thanks Brendan for the info and tip.
Much appreciated! Eric