Make MDE File Taking a LONG Time - What's Normal

[cp2599]

I'm creating an MDE file on a database with less than 20 forms and 10
tables. Does anyone know the average length it takes to create an MDE
file? How will I know when it's done? Looking at Task Manager it
says "Not Responding" ... is this normal? If it's not normal, any
suggestions I what I need to do?

 

[ruralguy via AccessMonster.com]

Have you tried compiling your db? <ALT> F11 then Debug>Compile
It sounds like there might be something wrong with the db. Fix any compile
errors before trying to make an MDE again.

 

[ruralguy via AccessMonster.com]

BTW, you should have already done a Compact and Repair on the db.

 

[Tom van Stiphout]

On Fri, 24 Apr 2009 13:31:25 -0700 (PDT), (e-mail address removed) wrote:

Less than a minute.
Try it on another computer.

-Tom.
Microsoft Access MVP

 

[cp2599]

Have you tried compiling your db? <ALT> F11 then Debug>Compile
It sounds like there might be something wrong with the db. Fix any compile
errors before trying to make an MDE again.



--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200904/1

Thank you for responding. The compile was done, but when I tried to
repair and compact the database an error resulted. Corrected that
error and the MDE went quickly.

 

[cp2599]

BTW, you should have already done a Compact and Repair on the db.



--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200904/1

Thank you for responding. The compile was done, but when I tried to
repair and compact the database an error resulted. Corrected that
error and the MDE went quickly.

 

[ruralguy via AccessMonster.com]

Excellent! Thanks for posting back with your success.

BTW, you should have already done a Compact and Repair on the db.

[quoted text clipped - 10 lines]

http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200904/1

Thank you for responding. The compile was done, but when I tried to
repair and compact the database an error resulted. Corrected that
error and the MDE went quickly.