Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 533
  • Last Modified:

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
0
aesmike
Asked:
aesmike
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists β€” all with no agents to manage and no additional licenses to buy.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
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

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered β€œyes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now