Version control for VBA Access code?

Question

Possible duplicate:
Version Control for VBA File

Is there any version control? If not, is there a good solution for collaboratively developing an MS Access 2007 database with VBA?

Answer 1

The only integrated VC solution for Access is Microsoft Visual Source Safe, however it is poorly designed and even Microsoft does not allow it to use it;). Some people call this the "Source Destruction System," but I personally know of success cases with its use. As a rule, this can be a good solution for small and medium-sized projects due to its limitations.

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

Another option is to create custom code to export the VBA solution using Application.SaveAsText (), a partially undocumented Access API function.

Answer 2

Microsoft has released an add-in Add-in for managing source code for Access 2010:

The source control allows integration with Microsoft Visual SourceSafe or other source code control systems that allow registration / registration of requests, forms, reports, macros, modules and data. You can also see the differences that were made to the objects.

Answer 3

I work with Access and Team Source Server Source Control. You need to switch the source control provider that Access is expecting; I used this tool, Sourcecode Control Switcher , to do this when we switched from VSS to TFS. After you switch, you can configure the source control settings in Access and create a .mdb connected to the data source from TFS. It works beautifully.