I've tried the code above in a MS Access 2010/Sharepoint 2007 environment and, like all past attempts with other similar Sharepoint refresh code, the following statement executes error-free, however, no actual refresh occurs:
DoCmd.RunCommand acCmdRefreshSharePointList
Subsequent manual...