Version Control for Access VBA code?

Question

Possible Duplicate:
Version control for VBA file

Does any kind of version control exist? If no, is there any good solution for collective development of MS Access 2007 database with VBA ?

remember to search for your question first, please. – Aaron Hoffman Apr 22 '09 at 14:53 — Aaron Hoffman, Apr 22 '09 at 14:53
sorry. quick preview search had shown nothing related. – Igor Konoplyanko Apr 24 '09 at 14:10 — Igor Konoplyanko, Apr 24 '09 at 14:10

score 3 · Answer 1 · answered Sep 14 '10 at 14:29

Microsoft have produced a Source Code Control add-in for Access 2010:

Source Code Control add-in allows 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.

score 2 · Answer 2 · answered Feb 20 '10 at 18:44

I work with an Access application and Team Foundation Server Source Control. You need to switch the source control provider Access expects; I used this tool, Sourcecode Control Switcher, to do so when we moved from VSS to TFS. Once you've switched, you can setup the source control settings in Access and build a source-control-connected .mdb from TFS. It works nicely.

juckobee · Accepted Answer · 2009-04-23T07:21:35.777

The only one integrated VC solution for Access is Microsoft Visual Source Safe however it's poor designed and even Microsoft internally avoid from using it ;). Some people call it "Source Destruction System", but I personally know success cases with using it. Generally, it could be a good solution for small and medium projects due to its limitations.

Here is a very critical article about VSS: http://www.highprogrammer.com/alan/windev/sourcesafe.html

The other option is to design your own code to export VBA solution using Application.SaveAsText() - it's partially undocumented feature of Access API.

Version Control for Access VBA code?

3 Answers3

Linked