I have played a little with MS Access 2007, verifying that it's working with TFS Msscci 2008. In order to get SCC integration, you need to install Access Developer Extension - a add-in that allows Access to use any Msscci provider (and a few other goodies...

Yet another tool that should be working with TFS Msscci Provider is RoboHelp. The reported problem is "Server Busy" error message display over Msscci dialog. The solution for this (until release of the new provider) is to create registry file (robofix...