Macro Help Access 2010

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?
Matt PinkstonAsked:
Who is Participating?
I would use a SharePoint Timed Job for this so that you are insured the workflow stays in sync and logged in one place
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.