Source control and versioning for ACCESS.

[Gary G. Little]

Is there any source control like Visual Source Safe or CVS for the VBA
source code within Access?

The personal opinion of
Gary Little

 

[Albert D. Kallal]

Is there any source control like Visual Source Safe or CVS for the VBA
source code within Access?

The personal opinion of
Gary Little

Yes, the standard VSS system works with ms-access. (kind of neat, because
you can even check in/out sql queries). So, indiviual forms etc. can be
checked in/out by a a set of developers working on the application. You see
a little "lock" or check mark appear beside each object. Here is a screen
shot:

http://www.members.shaw.ca/AlbertKallal/vss/index.htm
(note how a "lock" or a check mark appears beside each object you have
checked in/out.

Here is teh Info link for this:

http://support.microsoft.com/kb/837136/en-us

Download page:
http://www.microsoft.com/downloads/...f4-a916-48c5-8f84-44b91fa774bc&displaylang=en

You don't mention what version of access you using. The above is for 2003.

 

[Gary G. Little]

I checked the Access docs and found that there is via the developer
extensions.

The personal opinion of
Gary Little

 

[Gary G. Little]

Thanks for the reply Albert. I'm using access 2007. Do you know if one of
the freeware clients such as SmartCVS will work in the the same way? I've
got access to VSS via my MSDN Pro subscriptions, but the society I'm doing
this for will baulk at the $500 price tag. Yeah ... it's a freebie I'm
working on.

The personal opinion of
Gary G. Little

 

[Albert D. Kallal]

Thanks for the reply Albert. I'm using access 2007. Do you know if one of
the freeware clients such as SmartCVS will work in the the same way? I've
got access to VSS via my MSDN Pro subscriptions, but the society I'm doing
this for will baulk at the $500 price tag. Yeah ... it's a freebie I'm
working on.

Well, if you install the developer extensions for 2007, then source code
control works with VSS (visual source safe).

It is my understanding that products like SmartCVS works via the same
"standard" interface that VSS uses. So, my impression is that 3rd party
source code systems that are compatible with visual studio etc should thus
also work just fine with ms-access.

So, I don't about smartCVS, but if it follows a standard interface and works
with most development tools in the marketplace, then it should thus works
with access 2007. You just have to give it a try.

If you don't have a source code ribbon appearing in access, then you have to
install the a2007 developer extensions. You can find that here:
http://msdn2.microsoft.com/en-us/office/bb229700.aspx

If it works, then post back...I am interested also....

 

[Gary G. Little]

Thanks Albert. I shall give it a try and let you know.