Over the years, I've been asked about "Source Code Control" for Microsoft Access, since Access is one of more popular tools for a certain type of application development.  Although you could always manually check-in/out Access solutions, there was never a control similar to the one in Visual Studio that would allow you to do source control in a more "automated" fashion.

Well, it seem that the Microsoft Office (Access is a part of Office) team has released such an add-in for MS Access 2007.

Here are the details:

Overview

The Access 2007 Developer Extensions provide packaging and deployment tools and licensing and distribution agreements to make it easier for developers to bring solutions to market. Whether you are working in a small business or a large enterprise, as a third-party or an internal developer, Access 2007 Developer Extensions can facilitate the deployment and management of Access 2007 solutions.
The Access Developer Extensions include the following components:

  • Package Solution Wizard
    A wizard that creates a Windows Installer Package (MSI) to install your database and any supporting files and optionally includes the Access 2007 Runtime, or prompts the user to download the Access 2007 Runtime.
    IMPORTANT: The Access 2007 Runtime is currently not available. If you are packaging a solution:
    • Do not select the Require nothing and install the Access 2007 Runtime pre-installation requirement.
    • If you select Require the Access 2007 Runtime to be downloaded if Access is not already installed, send the solution only to users who already have Access 2007.
    This page will be updated with more information as soon as the Access 2007 Runtime download is available. For more information, see this Access Team blog post.
  • Save As Template
    Enables you to create database templates (ACCDTs) that can be featured in the Access 2007 Getting Started screen.
  • Source Code Control
    Integration with Microsoft Visual SourceSafe or other source code control systems to allow check-in/check-out of queries, forms, reports, macros, modules, and data. You can also see the differences that have been made to your checked out objects.

Here is the link for the download: http://www.microsoft.com/downloads/details.aspx?familyid=d96a8358-ece4-4bee-a844-f81856dceb67&displaylang=en

~ Robert Shelton