Quick Find: Search for:
Free Resources
from FMS
 

Demos

Email Newsletter

Technical Papers

Tips and Techniques

Links

Book Recommendations

View all FMS products for Microsoft AccessMicrosoft Access Resource Center

 

 

"Thank you! Thank you!
I just finished reading this
document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.
" 
- Darren D.
 
  

 

Speed Up Microsoft Access and Visual SourceSafe Integration

Provided by: Luke Chung, FMS President

Using Microsoft Visual SourceSafe (VSS) with MS Access for system development is great for tracking old versions, maintaining a professional Access development platform, and multi-developer environments. Being able to quickly see old versions of individual objects, differences over time, and check-in and check-out objects to prevent multiple developers from changing the same object are all wonderful features.

Unfortunately, as Access databases get more objects, VSS slows down and can sometimes take minutes to add a new object to the database. Waiting for VSS to prompt you for every new object not only wastes time (especially if you don't want to add a temporary object to VSS), it disrupts the rhythm of system development. Fortunately, there's an easy way to work around this.

Visual Source Safe is part of MSDN. By installing the Office/Access developer extensions/edition or Visual Studio Tools for Office (VSTO), VSS gets added to your Access menus.

Do Not Automatically Add New Objects to Visual Source Safe

In Access 2007, it adds the Source Control ribbon, and choose Options:

Microsoft Access 2007 and Microsoft Visual Source Safe

For Access 2003 and earlier, go under the Tools, SourceSafe menu and choose Options:

Microsoft Access 2003 and Microsoft Visual Source Safe

This screen appears. By default, the highlighted option is Yes.
Change it to No:

Microsoft Visual SourceSafe Options

This allows you to add new objects to your database without interruption.

When you are ready to add your new objects to Visual Source Safe, simply choose the [Add Objects to SourceSafe] option from the same Source Safe ribbon/menu:

Add Objects to Visual SourceSafe from Access 2007
Access 2007
Add Objects to Visual SourceSafe from Access 2003
Access 2003 or earlier

select your new objects, and them to VSS all at once.

Return to the tips page


Questions  l   Web questions: Webmaster   l   Copyright © 2008 FMS, Inc.

Celebrating 21 Years of Software Excellence