Access: Run-time error 13 Type MisMatch

=========
QUESTION
---------
I converted a Microsoft Accessdatabase from .mdb to .accdb format, and now when I run my usual VBA code to export a report to PDF, it gives me the error: Run-time error 13: Type mismatch

=========
ANSWER
---------
If you are not using an ADO object library, clear the reference to the library. To do this, follow these steps:
--Click the Microsoft Office Button, and then click Open.
--In the Open dialog box, locate and select <DatabaseName>, and then click Open.
--On the Database Tools menu, click Visual Basic in the Macro group to open VBE.
--Note You may also press ALT+F11 to open VBE.
--On the Tools menu, click References.
--In the References - <DatabaseName> dialog box, click to clear Microsoft ActiveX Data Objects, and then click OK.

=========
EXAMPLES
---------

=========
APPLIES TO / KEY WORDS
---------
Microsoft Access
Error

=========
REF
---------
http://support.microsoft.com/kb/927678

---
http://www.anysitesupport.com/access-run-time-error-13-type-mismatch/
http://anySiteHosting.com

  • 17 Users Found This Useful
Was this answer helpful?