I am building an application in Access 2010 that is publshed to sharepoint through Access Services. I am trying to write a simple Before Change Data Macro that looks up information from a separate table and writes it to a field in the original table.
After saving the macro, going back to the table to which it is attatched, and editing a record, I get the following error:
The Microsoft Access database engine encountered an error while communicating with SharePoint. More detailed information: 'Error executing validation macro: .'
This error seems to be present in every macro where the LookuipRecord action is used, no matter what the context.
When I attempt to edit the data in the table directly, this error prevents the macro from performing the desired action
When the data in the table is edited through a datasheet form in the Access 2010 client, the same error is displayed. However, the macro appears to work as expected--the desired value is pulled from the lookup table and written to a field in the original table.
When that same datasheet is viewed in a browser through Access Services, the macro also appears to work as expected, except without the error.
Does anyone have an idea what is causing this error and how to fix it? Could it be a problem with my host? Here is the XML of the macro, which is attatchd the "Contacts" table and looks up to the "Companies" table:
<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<Argument Name="Value">[Companies].[Company Name]</Argument>