Comparing Strings

[Paul H]

I need a utility of some kind where I can compare similar procedures, SQL strings or really any two documents. I am trying to debug code and this would save me a lot of time. I've used other database programs that have this tool, but this is one of many that Microsoft Access doesn't provide, does it?

I want to see them side by side with the different portion highlighted.

[ssanfu]

I need a utility of some kind where I can compare similar procedures, SQL strings or really any two documents. I am trying to debug code and this would save me a lot of time. I've used other database programs that have this tool, but this is one of many that Microsoft Access doesn't provide, does it?

I want to see them side by side with the different portion highlighted.

I use "VBA Code Compare" at formulasoft.com.

If I just want to compare portions of code. I create 2 new modules and paste the portions in different modules, then do the compare. It does have limitations, but it does do a great job comparing.

It is free, but like I said, it does have a few limitations: can't synchronize between windows, can't print differences, other minor issues..