Access: Type Mismatch Run-time Error After Converting to ACCDB Format

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.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s