Report Issues when in Access on SharePoint

Access is great on SharePoint.

It sites like a magic interface between list data and your front-end of choice. In my case just using Access as front-end in SharePoint .

While fiddling with Access in SharePoint in order to create a custom CRM backend I kept getting the following error:


This is the error I get on a client.. not very specific.

So going on the local machine I get:

Invalid reference ‘Field_Name