Using Visual SourceSafe - Integrating VSS with Access 2007

This article is a part of SourceSafe / VSS Tutorial

With Access Source Code Control add-in, Visual SourceSafe can be integrated into MS Access to source control Access queries, forms, reports, macros, modules and data.

SourceSafe stores each Access objects as a text file. When you add an Access object to SourceSafe, Access exports the object to a text file in the working folder. Then the Access Source Code Control add-in adds the file to SourceSafe Database. When you check out/get an Access object from SourceSafe, the Access Source Code Control add-in copies the corresponding text file from SourceSafe to the working folder. Then Access imports the text file into MS Access database and turns the file into the appropriate Access object.

 

To integrate SourceSafe with Access 2007, please follow the steps below:

  1. Install Access 2007 Developer Extensions, which includes source code control component. You can download it from: http://www.microsoft.com/downloads/details.aspx?familyid=d96a8358-ece4-4bee-a844-f81856dceb67&displaylang=en

  2. Choose SourceSafe as the current SCC (Source Code Control) provider. For information on how to do it, see this: https://www.dynamsoft.com/codepool/microsoft-source-code-control-interface-msscci-registry-entries.html

  3. Open the database in Access 2007.

  4. Add the database into source control of SourceSafe. Click menu Source Control and click Add Database to SourceSafe button.

Add Access database to SourceSafe (Add Access database to SourceSafe)

  1. Then Access will prompt the following warning dialog box. Click Yes.

  1. Log into a SourceSafe database and select the location to store the project.

Log in SourceSafe (Log in SourceSafe)

Add the project to SourceSafe (Add the project to SourceSafe)

  1. Add the Access objects into SourceSafe.

Add Access objects into SourceSafe (Add Access objects into SourceSafe)

  1. Now the objects are in the source control of SourceSafe. You can find the SourceSafe functions by clicking the Source Control tab. You can also access some of the functions by right-clicking the items.

SourceSafe functions (SourceSafe functions)

SourceAnywhere - the SQL Server-based SourceSafe Replacement

The SQL Server-based Source Control Software Designed to be a SourceSafe Replacement

SourceAnywhere for VSS - the Fastest SourceSafe Remote Access Tool Recommended by Microsoft

The Fastest SourceSafe Remote Access Tool Recommeded by Microsoft

Links: Previous article ««: Integrating SourceSafe / VSS with Visual Basic 6.0 Next article »»: Integrating SourceSafe / VSS with Access 2003 SourceSafe How To series home page: VSS / SourceSafe Tutorial