Access VBA Source Code Comparison

I'm looking for a set of tools to help me manage my vba code.  I have developed one product but has slightly different versions, depending on where its installed.  It's installed in 10 different customers so that's 10 different versions of the code.

I want to perform a gap analysis to analyze the differences between installations.  One of the most critical things I need to do is to produce a list of differences down to the function/procedure level.  

In other words, Customer A and Customer B have very similar versions to each other.  98% of the code is the same.  However, 2% of the subs or fucntions are different.  "Show me a list..."

Is there a commercial version of this available so I don't have to roll my own?

Thanks.
-Mike
LVL 10
aesmikeAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Mike ... certainly you are aware of

http://www.fmsinc.com/MicrosoftAccess/DatabaseCompare.html

?

How's the beemer ?

mx
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I own and use Total Access Detective. It is VERY thorough, and is possibly the best out there for what you're looking at. It can get very granular, but then that's what you're looking for with something like this.
0
 
ducky801Commented:
If you're looking for a free solution.  I would suggest a program i use at work to compare large text files.  It is called Beyond Compare.  
Essentially, you tell it the 2 files that you want to compare and it does a character by character comparison and shows your differences in red.  it will read the text out of any file that has 'raw' text in it, regardless of the extension.  So you can just export your modules, and compare.
 
Hope this helps
 
AR
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I don't think Beyond Compare is free, since I have a licensed version.

mx
0
 
ducky801Commented:
@DatabaseMX:
You're right.  I thought of that just after i clicked submit.  Silly me.  I guess it just seemed free to me because I dind't pay for it.  How much was your license, out of curiosity?
 
AR
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
It's an excellent program for sure, but probably not quite what Mike needs in this case.

Check their website for the cost.

mx
0
 
jerryb30Commented:
Will functions/procedures be named the same?
0
 
aesmikeAuthor Commented:
Thanks, Joe.
Sorry for the delay.  Haven't used EE in a while and I guess the email alerts were turned off.  
FYI, EE took away my unlimited questions status.  what is the world coming to when I have to use earned points!  I guess at EE it's "What have you done for me lately"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.