Update: Solved. I would have deleted the question, but don't see a way to do that, nor can I edit the previous postings. I would mark this as solved if I could find out how to do that.



I removed the reference to DAO 3.6 Object Library, set a reference to Microsoft Office 16.0 Access Database Engine Object Library, and changed the code as follows:


Dim db As DAO.Database
Dim rs As DAO.Recordset


to:


Dim db As Object
Dim rs As Object


Thanks to Albert Kallal in another forum (found via a search) for this suggestion.