locked
VBA hangs when closing Access, PPT, Outlook, Excel RRS feed

  • Question

  • Windows XP Pro, Office 2003 SP2

     

    When I open a database in Access, work with it, then close it, it closes immediately.

     

    When I open a database, then open the VBA Editor, Access fails to close immediately, but instead shows the error dialog “Unexpected critical error; can’t start program.” I assumed it was trying to compact the database, so I turned that option off, to no effect. Click OK in the error dialog dismisses it. Access stays running.

     

    After a while (20 secs?), a new error dialog opens with the message “Runtime error ‘429’: ActiveX component can’t create object.”

     

    Same thing happens when I open the VBA editor in Outlook, PowerPoint, and Excel, but not in Word.

     

    What is going on here, and how do I fix it?

    Tuesday, July 11, 2006 12:33 AM

Answers

  • Fixed by a complete Uninstall and a fresh install.

    Saturday, July 15, 2006 3:24 PM