Creating MDE Issue

[ezfriend]

I am attempt to create a MDE file, but MS Access seems to freeze.

The application has db1.mdg (forms, reports, modules) and db1_be.mdb (three tables). Simple database. When I try to run the MDE wizard to create it, MS Access seems to freeze. CPU is running at about 25 (20,068K).

Any idea?

MS Access 2003.

 

[CraigDolphin]

My guess is that you have a compile error in your code somewhere.

try opening up the original mdb file, open the vba editor, then go to the debug menu>compile. Fix any errors that it throws up. Once everything is clear you should be ok to create the mde. Be aware though, that you need to have error handlers for all your code in an mde or else it'll crash any time its hits an unhandled error/exception.

HTH

 

[ezfriend]

That was a great help. Although I didn't get any errors, after I ran the compile, I was able to create the MDE file in a split second.

Thanks a bunch, CraigDolphin.

_ez

 

[CraigDolphin]

Hmm. Odd....well, glad you got it working in any case

 

[April15Hater]

Compile worked for me too!

My situation was that the power went off while I was working on security settings. When I went in to make an MDE, it would make a db1.mdb file and freeze up while never making the mde. I compiles and life was good after that.

Thanks!

Joe