Many organizations still rely on Microsoft Access for essential business needs. Fortunately, you don’t have to choose between your legacy Access applications and Microsoft Office SharePoint Server 2007. MOSS allows you to integrate those Access applications into SharePoint for an even better way of handling your data. Explore how you can use these tools to build new solutions for your organization.
The Access Team Blog has a good discussion of Windows SharePoint Services as it relates to Access.
And we've got lots more information on this topic. Take a look at Introduction to integrating data between Access and a SharePoint site.