Ran into separate issue with connecting Access to Arc. I found this help article which I think explains my problem. Posted a screenshot of the instructions below and a link to the article. I downloaded the appropriate engine driver (I believe) as it says here. I even restarted my computer after doing so, but the new accdb driver is NOT showing up. See additional screenshots. Maybe the issue lies in the 32-bit/64-bit difference? Any insight would be hugely appreciated.
If I use this extension C:\Windows\System32\odbcad32.exe
the driver DOES show up, but still the connection in ArcCatalog fails.