Access™ 2007 VBA Programmer's Reference

21.4. Source Code Control Support

The last ADE tool we'll discuss here is the support for standard Source Code Control programs. In this day and age, from single-person shops to huge corporations, the use of source code controls to version and backup software under development is widespread and has been adopted as an industry standard. Source code controls can be effective for versioning and protecting software and any changes made to it, especially when there are multiple users accessing and updating the same code for long periods of time. While there is no mechanism built into Access to version a database or the objects within it, installing the ADE adds the Source Code Control add-in, which can be used to systematically version an Access database development project.

Unfortunately, the ADE does not include a Source Code Control (SCC) program itself, but it does give the user the capability to use Access with a standard SCC program. The standard SCC program is defined as any SCC provider that is registered to Windows as a standardized source code control provider. While many different source code control applications are available on the market, the following examples use the SCC add-in with Microsoft Visual Source Safe 2005 (MS VSS), the latest release of the MS VSS available with the Microsoft Visual Studio .NET 2005 product.

21.4.1. Install the Source Code Control Program

If there is already an SCC program such as Microsoft Visual Source Safe installed on the machine, then ...