type mismatch error in Access after upgrading to Office 2021

Question

After recently upgrading from Office 2010 to Office 2021, a report fails with a type mismatch error. I've made no changes to the code, and it still works in Access 2010. In addition to the code below, RecCount is declared Public Integer.

The references are: Visual Basic For Applications; Microsoft Access 16.0 Object Library; OLE Automation; Microsoft Outlook 16.0 Library; Microsoft ActiveX Data Objects 2.1 Library.

Any suggestions would be greatly apreciated.

Answer 1

LarryA15,

Try "adOpenStatic" instead. If "adOpenKeySet" cannot work.

Also try to make sure ADO is reference the the VBA editor.

Also, try 2.8 or 6.1 instead of 2.1. 2.1 is too old.

Answer 2

Changing 2.1 to 6.1 did the trick. Thanks to everyone who responded.