Speed Up Microsoft Access and Visual SourceSafe Integration
Provided by: Luke Chung, FMS President
Using Microsoft Visual SourceSafe (VSS) with Microsoft 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.
Return to the tips page
|
