Tool that color codes SQL for Access

I personally find it hard to write nested SQL in MS Access, as it is hard to follow the parentheses throughout the SQL in a query.  For instance, when one write a formula in Excel 2007, the parentheses and other parts of the formula are highlighted in various colors so it is easy to tell where you are in the code.

My question is; is there a tool that will enable me to do something like this in Access 2007?  It doesn't have to actually work with Access, as I can simply write the SQL in the tool, and paste it into Access if I need to.  Thanks in advance, Jon

p.s. Is it correct terminology to call SQL "code", or is it called something else.  Additionally, is it correct to call a formula in Excel code or is it simply referred to as a formula.
Jon BredensteinerProject ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
I recommend this - which is what I use:

http://www.ultraedit.com/

mx
0
GRayLCommented:
Indentation is the widely accepted manner by which one 'keeps track' of where you are in complex formulas.  However, Access will completely mess up a highly structured SQL string (not code).  I use Notepad to 'store' the structure of complex and detailed strings.  VBA code is contained in a module.  If the SQL string is part of that code, under that circumstance you could call it code.  As it sits in the SQL View of the query builder it is a string.  Excel has both formulae and code (VBA).  Just my 2¢.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JezWaltersCommented:
PSPad will do this for you:

www.pspad.com
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

JezWaltersCommented:
Forgot to say PSPad is free!
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
With Ultra Edit, you can get formatting like this. Also,  UE is infinitely useful for MANY other things also.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
With Ultra Edit, you can get formatting like this. Also,  UE is infinitely useful for MANY other things also.
UltraEdit-SQL-Formatting.gif
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Sorry ... accidentally hit submit the first time
mx
0
Jon BredensteinerProject ManagerAuthor Commented:
Thanks guys for all of the suggestions...

What about Dreamweaver 8, will it work too?  I already have it installed on my PC.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
DW8 ... ahh, why not just try it :-)

mx
0
Jon BredensteinerProject ManagerAuthor Commented:
Good point :)
0
Jon BredensteinerProject ManagerAuthor Commented:
So, I don't think DW8 can be used to edit SQL.

I tried all of your suggestions, and they all look promising; however, I have to say GRayL that Notepad++ was the easiest to learn in a short amount of time.

It was easy to get Notepad++ to highlight (color) the different parts of the SQL string.

I did figure out how to change the syntax to SQL in PSPad, and it did allow me to quickly figure out where I was in a nested string; however, I could not figure out how to get it to highlight (color) the different parts of the string.

UltraEdit only had an option to view the SQL as MySQL, but not standard SQL, and I'm not sure if that really matters, but the other two apps did have an option for SQL standard.  UltraEdit did color code the syntax like Notepad++ did; however, it isn't free :)

I also found a tool named DTM SQL Editor Professional, which not only lets me edit the SQL, it connects to just about any database you can think of, and return the data, edit the views, view permissions, and just about anything else you can think of.  It also highlights the SQL keywords and comments; however, it does not highlight or track the parentheses like Notepad++ does, which is what I was really looking for in the first place.
0
GRayLCommented:
Thanks, glad to help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.