Hi,
I'm using Access 2016 linking to a Sharepoint 2013 online list. I import spreadsheets and run an append query to add the new items to the SP list. For some reason, for the last several weeks, it is doubling the line items that it appends.
For example, I just imported a spreadsheet with 36 rows, ran the append query and it added 72 rows to my SP list. I've made sure there were no blank rows in my access imported table, done compact/repair, increased the time-out in properties, made sure it's connected to the SP list, etc. I have not been able to find any reason that this is happening.
Has anyone else experienced this?
Thanks!
Toni