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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
GRayLConnect With a Mentor Commented:
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
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Connect With a Mentor Commented:
I recommend this - which is what I use:

http://www.ultraedit.com/

mx
0
 
JezWaltersConnect With a Mentor Commented:
PSPad will do this for you:

www.pspad.com
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
JezWaltersCommented:
Forgot to say PSPad is free!
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
With Ultra Edit, you can get formatting like this. Also,  UE is infinitely useful for MANY other things also.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
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
All Courses

From novice to tech pro — start learning today.