Thank you Connecticut Access Users Group for a very interactive session. In prepping for our session, I got to learn about the great abilities Access 2007 brings to the overall ecosystem that is WSS/MOSS. As promised, here are some resources to jumpstart your exploration...
And for those willing to get there hands dirty :)
Bidirectional data, cache it, synchronize, work offline...Access+WSS/MOSS, better together!
Oh, and let's not forget, with SP1 shipped, you don't have an excuse not to live the WSS/MOSS life (or the Office Live lifestyle).