=========
QUESTION
———
I converted a Microsoft Access database 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