Friday, October 28, 2005

Microsoft Access was unable to create an MDE database

Saw this message? Here a list of 15 reasons why this can happen. But certainly one is missed. If you have an ActiveX control on a form, and since you inserted it – control was upgraded to a new version – this could be a reason. I had it several times with Windows Common Controls: Treeview, Listview, etc. So what to do? Made a backup of your MDB, make sure that you have only references you use, and for all controls you use – you have references. If you use Windows Common Controls - make sure you use either comctl32.ocx or mscomctl.ocx, you can use only one in same mdb. Decompile mdb and compile again. If this does not help - start to remove forms with ActiveX controls one-by-one and each time make mde - then you find which one cause the problem. This one you need to recreate it – create a new form, insert an ActiveX control there, using menu Insert, then copy/paste all other controls and copy from old form and then delete it. HTH!

3 comments:

  1. "list of 15 reasons" now upgraded to 16! Great!

    ReplyDelete
  2. Anonymous11:37 AM

    Nice blog for regarding MDE error. You can check this blog also for more information on http://officerepair.wordpress.com

    ReplyDelete
  3. Hassan6:51 PM

    !Can thank >enough

    Helped me a lot.

    ReplyDelete