Today's guest writer is Mike Sullivan - a tester on the Access team With the release of Visual Studio Team System 2008, we've recently received questions from several customers regarding whether or not Team Foundation Server (TFS) can act as a source code control provider for the Access source code control (SCC) component. The answer is yes,
Office 2010 Standard X86! Although many folks refer to Access; source code control component as “SourceSafe integration,” that only tells part of the story. SCC integration within Access is fully compatible with any provider that implements the Microsoft Source Code Control Interface (MSSCCI). Although Visual SourceSafe is one of the more widely used MSSCCI providers,
Windows 7 Enterprise, there are several other products that implement this interface, including Team Foundation Server 2005 & 2008 as well as IBM ClearCase. However, MSSCCI support in Team Foundation Server is not native and requires an additional add-in available for download: MSSCCI Add-in for Team Foundation Server 2005
MSSCCI Add-in for Team Foundation Server 2008 Of course, to enable SCC functionality from within Access, you;ll also need the Source Code Control add-in. This shipped as a free download as a part of the Access Developer Extensions for Access 2007 and as a separate free add-in for Access 2003: Access 2007 Developer Extensions
Access 2003 Source Code Control Add-in If you;re interested in taking this configuration for a whirl,
Office Professional 2007, you might want to download the Team Foundation Server Virtual PC image that has been made available by the Visual Studio team. Included on this virtual PC are copies of Visual Studio Team System 2008 and
Office 2007 Enterprise SP1 (though Access is not installed by default on this image – you;ll need to go to Add/Remove programs within Control panel and launch setup to install Access). This trial image is good through December 31, 2008. To get the Virtual PC image working,
Office 2007 Ultimate Product Key, you;ll also need to install the Access Developer Extensions (the MSSCCI add-in is preinstalled). Since VSS is the default MSSCCI provider on the machine, you;ll need to tweak a registry key to get Access to use Team Foundation instead: Path: HKEY_LOCAL_MACHINE\SOFTWARE\SOURCECODECONTROLPROVI DER
Key: ProviderRegKey
Value: SOFTWARE\Microsoft\Team Foundation Server MSSCCI Provider Hopefully those of you curious about support for TFS have had your questions answered,
Office Enterprise 2007! <div