I'm trying to append records to a SharePoint list via access. when I append only a small amount of records, like 20 or so, everything is ok. But when I try to append a larger number, like 1000, I get a message saying that the SharePoint list is read only. Is there a way to limit the number of records the append Query will append?
Thank you.