I have a couple MS Access 2010 tools that are frontends with SharePoint lists as the backend. They work fine for all users but one. When he clicks a button I made, it runs a couple queries to update SharePoint lists. One adds a record to a history list, and the other updates some fields in the main list. The main list update query cannot run and gives error 3073. He has access to the sharepoint lists and has made changes to the data successfully. If we run the same query from a different test form in the database then the update works ok.
The main form is a split form with a data source of the list that is being updated. It is set to snapshot. Setting the form's data source to a snapshot query of the list didn't help. He is using interoperability Access (his version of Office does not have MS Access included), but so are other users and it works for them.
How can I get it so the last user can update the list data from the main form?