Hello -
I've seen similar issues posted elsewhere, but none of the solutions have worked for me. I linked a SharePoint list to Access to serve as a UI for updating the list. From the linked table, I created queries to show the information different groups would need to update, then created forms for each group. As far as I could tell, everything seemed to work as expected while the database was on my hard drive. However, when I loaded it to the SharePoint site where I planned to store it for general access, random items started throwing a "Could not find field" error when users would attempt to change them. I checked all the data types and they all seem to be in order. I refreshed the table link and even created an entirely new database. I'm at a loss as to what could be causing this to happen - there doesn't appear to be any real logic behind which records throw the error. Can anyone help? I'm quite new to Access, so I hope this is just something obvious I'm missing.
Thanks!