Hi all, looking for some feedback and advice.
I have a Access backend linked to a SharePoint list. I run daily updates from several sources via the Access end to update the lists. One of the updates I run takes well over an hour (sometimes 1.5 hours, depending on the network).
What I'd like to do is, as the data gets Updated via a query to SharePoint, I'd like to delete the data from the source table in my Access end as it goes.
The reason is, if the update fails for any reason (record locking, network issues), I have to run the whole update again.
Ideally, I would only have to update anything that hasn't already been updated that day (the balance of the source table) if it fails.
Any advice or experience with this would be appreciated, thanks.
I have a Access backend linked to a SharePoint list. I run daily updates from several sources via the Access end to update the lists. One of the updates I run takes well over an hour (sometimes 1.5 hours, depending on the network).
What I'd like to do is, as the data gets Updated via a query to SharePoint, I'd like to delete the data from the source table in my Access end as it goes.
The reason is, if the update fails for any reason (record locking, network issues), I have to run the whole update again.
Ideally, I would only have to update anything that hasn't already been updated that day (the balance of the source table) if it fails.
Any advice or experience with this would be appreciated, thanks.
