You might receive a Run-time error ‘13’: Type mismatch after converting a Microsoft Access database from .mdb to .accdb format.  The solution might be as easy as removing the reference to the ADO object library, if you are not using it.

  • Open the Access database in question.
  • Open the Visual Basic Editor (VBE) by pressing ALT+F11.
  • On the Tools menu, click References.
  • In the References dialog box, uncheck Microsoft ActiveX Data Objects, and click OK.