In this blog entry Access 2010 and Sharepoint discussion I mentioned an interesting discussion A second thread titled Access 2010 with Sharepoint 2010 was also started with a lot of additional interesting discussion. Keep checking back on these threads. David Fenton, as expected, is asking some tough questions as are others. I expect this discussion to go on for a while.
Note that you might want to click on the Options button on the right hand side of the grey bar and choose to view the thread as a tree.