I have several databases that are scheduled using Windows scheduler. They are set to publish results to a SharePoint list. The issue I am finding is every once in a while the SharePoint list becomes disconnected from the database. The database will appear to finish running but the results will not actually upload to SharePoint. I'm trying to find code that refreshes/relinks the SharePoint list so I do not have to worry about this. Below is the code I have tried and it doesn't appear to work. Anyone have any suggestions?



Code:
mySQL = "SELECT * FROM [Table Name];"
Set rs = CurrentDb.OpenRecordset(mySQL)
rs.Requery
DoEvents
rs.Close