InfoPath Dev

What would be the code necessary to keep infopath updated/ synced with access. As we are writing into the access db we wanted to have it be reflected in infopath. How would we go about this? Thank you.

Secondary data connection that receives from Access.  After making that DC, drag the repeating group of that DC to your canvas and let it create a repeating table.  That will always show the current data from the source.  If you write to the Access DB from within the form, then just have your button requery the receive DC, and it will show the updated Access info in InfoPath.  Shouldn't require code.

Is it possible to requery on a timed interval without having to click "refresh"?  And when making the second connection, I want to have the most recent entry seen instead of the entire list or the first entry into the table, how would I go about that? Thank you very much.