I think there are various approaches to this. I haven't experiemented with this myself, but I think the easiest solution would be to have a query table in Access and link this to MapPoint. You can then write some Access code to move data from different time snapshots into this query table, and refresh the link to MapPoint every time the data in this query table has changed.