In Microsoft Access 2013, go to
File >> Options >> Current Database >> Caching Web Service and SharePoint tables
Then untick the checkbox for “Use the cache format that is compatible with Microsoft Access 2010 and later”
Found the solution HERE. Thanks manishramanan for asking the question and thanks BROCKANDREWS for answering it. Added to the blog here in case the original post disappears or link breaks.