locked
version control for access RRS feed

  • Question

  • I've been using this access program for about 15 years but we haven't had the need for any changes in a long time. Recently I started using git on our website development and live site. And now that I'm needing to hire out some changes for our access program I'm realizing that there literally seems to be no way to version control access. After getting used to some very basic git commands, dealing with changes to access is rather cumbersome because you just have to copy changes over from test to live. Or at least, that's how I've been doing it.

    I'm not a developer myself but I know a little bit about some of the work flow. It would be really awesome if microsoft access files were similar to a visual studio solution so the entire thing could be under source control.

    Are there any solutions besides manual documentation?

    Wednesday, November 4, 2015 6:34 PM

Answers

  • Up through Access 2010 source code control was available for Access databases via the MSSCCI interface. It works easily with Visual SourceSafe (long deprecated) and with Visual Studio Team Foundation Server. I believe there are MSSCCI providers for other source code control systems as well although I haven't used any.

    With Access 2013 Microsoft removed the feature. If you can't use Access 2010 there are some 3rd party add-ins available so it might be worth searching. I haven't used any of the 3rd party tools. I still use Access 2010 for development because source code control is essential for me.


    Paul

    • Marked as answer by ZenMasta Thursday, November 5, 2015 6:14 PM
    Thursday, November 5, 2015 12:08 PM

All replies

  • After getting used to some very basic git commands, dealing with changes to access is rather cumbersome because you just have to copy changes over from test to live. Or at least, that's how I've been doing it.

    ...

    Are there any solutions besides manual documentation?

    Hi ZenMasta,

    With my (I counted them) 88 applications, it is very hard to document what the status of each application is, and what the changes are/were. So I developped a technique that all this can be done dynamically, where the software itself is the source of the documentation.

    When the user gets a new version, he gets a (compiled) copy of the application that I use for development. In fact this user gets Always the "latest" version.

    To do my developping work I set a global boolean indicating that the application is in the development mode. I can build in new code using a construction like: 

             If (glo_dev) Then
                  new code lines
             Else
                  Original code lines
             End If

    In this way I can develop and check new parts, while, when installing this before the new code is completely finished, the user won't "see" it. After accepting the new code the line "If (glo_dev") Then" is converted to  "If (TRUE) Then". And after some time I do the clean up to remove the Original (old) code.

    The situation is even more complex in my case, while every application shares a referenced library database with generalized functionaity that accounts for more then 95% of all the code that is used. The library database changes continuously to add more functionality, or improve it.

    With this way of working I have no problems with version control. A user gets always the "hottest" version of his application, But it depends of the glo_dev value what is available to the user.

    Imb.

    Thursday, November 5, 2015 7:28 AM
  • Up through Access 2010 source code control was available for Access databases via the MSSCCI interface. It works easily with Visual SourceSafe (long deprecated) and with Visual Studio Team Foundation Server. I believe there are MSSCCI providers for other source code control systems as well although I haven't used any.

    With Access 2013 Microsoft removed the feature. If you can't use Access 2010 there are some 3rd party add-ins available so it might be worth searching. I haven't used any of the 3rd party tools. I still use Access 2010 for development because source code control is essential for me.


    Paul

    • Marked as answer by ZenMasta Thursday, November 5, 2015 6:14 PM
    Thursday, November 5, 2015 12:08 PM
  • Sounds crazy to me that they would remove it unless they have something new in the works... but then why deprecate without releasing a replacement. Git has blown up over the past couple of years as you know and MS even implemented it into TFS

    Thanks for both of your comments. with the Maybe 2017 we'll see some kind of transition into visual studio, that would probably be pretty cool.

    Thursday, November 5, 2015 6:14 PM