I have a sharepoint list that I have connected to my access DB.
I need to create a macro that will kick off each day that will update a field "SyncDate" in each record to the current date. By doing this the SharePoint update workflows should kick in doing the individual updates I need from my various lists.
What I need is instructions on how to create a simple macro to update SyncDate in my DB table called table1
Then is there a way to schedule it?