|
Free Resources from FMS |
|
|
|
|
"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. |
|
|
|
|
Microsoft
Access Resource Center
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:
For Access 2003 and earlier, go under the Tools, SourceSafe menu and choose Options:
This screen appears. By default, the highlighted option is Yes.
Change
it to No:
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:
 Access 2007 |
 Access 2003 or earlier |
select your new objects, and them to VSS all at once.
