Speeding Up Microsoft Access and Visual SourceSafe Integration: Powet Tip

Luke Chung of FMS, posted about how to avoid performance slowdowns when adding lots of Access objects to Visual SourceSafe. Here's an excerpt: "Using VSS with 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, […]

Luke Chung of FMS, posted about how to avoid performance slowdowns when adding lots of Access objects to Visual SourceSafe. Here's an excerpt: "Using VSS with 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 same object are all wonderful features.

Unfortunately, as Access databases get more objects, VSS slows down and can sometimes take minutes to add new object to 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."

[Source]