CODEWITHSUNDEEP
version-controlms-access-2010
tbaker818
tbaker818

Reputation: 121

Source Code Control / Version Control in MS Access

This is a general question about the topic. I ran across a post which gave VB script code for version control. I've been developing with Access for a while, but have learned entirely on my own and can be pretty ignorant of the the broader IT world. I got the code to work for me, but I'm lost on how to put it to work as a system.

To give some context, I have an example situation that maybe this kind of thing could solve. I'm now working on two versions at once (1.2 and 1.3) because the first version we'd like to release has to be tested where it's to be used in China. They were out of the office for a week due to the Chinese new year, in the meantime, I'm working on 1.3. Now, any changes I have to make to 1.2 of course have to go into 1.3. Actually, it's worse than that because clarity over the fact that we'd have to do this in two separate releases didn't emerge until work had been done which in hindsight went further than we could incorporate in 1.2.

The code in the post basically dumps all of the info about forms, reports, VBA, and macros into a bunch of text files (for some reason not tables, and maybe that has something to do with the fact that I'm working with Access 2010 rather than whatever version this code was created for.) Apparently, it can then reconstruct an application from those same text files.

What do I need to understand about source code control to make such a thing work for me? I recognize that might not be something you'd want to explain in a post, but can you point me in the right direction information-wise?

Upvotes: 1

Views: 3706

Answers (1)

iDevlop
iDevlop

Reputation: 25262

While this question is 3 years old, it might be of interest to some to have an answer anyway.
AFAIK, accesssvn.codeplex.com -cited by @Robby Shaw - is not working and not maintained.
Today I see 2 products usable products for VCS inegration:

Apart from VCS, you could also use a database compare tool like Microsoft's Database Compare 2013

Also worth considering, Accdbmerge, a tool to merge 2 databases.

Upvotes: 3

Related Questions