MDE not working

[mani]

Hi. I have got a small database, I have split it into front and back end. I then try to make an MDE out of the front end and after going to tools>db utilities>make MDE file, i got the save as box open up and i pressd save to my desktop,the box disappears and the screen is just blank(like there is no database file has been open,at the bottom of Access it says Make MDE/ADE.
And it just crashes.. it doesnt come up with any errors.
If anyone has any information pleeeeeaaaseee help.......

 

[Haz]

Thanks guys for the great help in here, i have spent few hours reading in these forums which is very benefitable for everyeone.

back to my subject, mani posted this thread asking what is the problem not getting mde created. I have the same issue, i have converted the mdb from 2000 to 2002-2003 version. I don't have any modules or macros code to compile. When I click on make MDE file.. it tell me to save it and I did. after that it freeze and didnt do anything. Please help....

 

[RuralGuy]

Have you examined the system event logs to see if there is a clue as to what is happening?

 

[Haz]

I checked the application event log, and found this message "Hanging application MSACCESS.EXE, version 11.0.6355.0, hang module hungapp, version 0.0.0.0, hang address 0x00000000" I tried it again today and still doing the same thing. Maybe I need to do it in another computer or my home computer. Thanks for the tip.

 

[KeithG]

Is it a large db with a lot of objects? Have you compiled you code?

 

[Haz]

The size is 1.12MB, 18 tables, 12 queries, 11 forms, and 16 reports. How would I compile the code? Do I need to do that for every object seperately?

 

[Haz]

Thanks, I found error in the code of one form that i dont need anymore. I delete it. it work now....

 

[RuralGuy]

Well now there's some good news. Thanks for posting back.

 

[Niniel]

That compiler really is your friend.

Although you've solved your issue, here's something I've run into a couple of times - I created my db in A2003, but in 2000 format [default]. I then changed it to 2003 format. The compiler found a couple of errors, but the oddest thing was that apparently, the DAO library wasn't [properly] linked. Had to do that before I could make the MDE.