Sorry if this is in the Wrong Thread....
I have a macro which connects to a Access 2016 DB using the Code below. This was working fine for Excel 2010, 2013 & 2016 without any issues and suddenly (I think after a MS Office Update) it simply crashes Excel 2013, but 10 & 16 work fine. Can someone please help here as I'm really struggling to understand why it stopped working and more importantly how do I fix it. I do not get an error, Excel simply goes into not working and restarts.
Code to open DB, there is other code to perform update but I can categorically say the highlight code crashes Excel 2013
Dim DBOpen As Object ' ADODB.Recordset
Dim strConn As String
Dim strTargetDB As String
Dim strQry, strMsg, MyPath As String
Dim lngRecs As Long
Dim db As DAO.Database
Dim MyTable As DAO.Recordset
MyPath = ThisWorkbook.Path & ""
Set db = DBEngine.OpenDatabase(MyPath & "{BDNAME}.accdb")