hi
is there any tool or add-on to color-code SQL keywords in the access-2007 SQL view, like in SQL Server?
thank's in advance
views:
30answers:
1
+1
A:
There is no way I know to hook the SQL View of the QBE in Access. Your only choice would be to use an external SQL editor that provides this feature and then paste the SQL into SQL View. However, I would caution doing that, since Access/Jet/ACE has its own SQL dialect and is very picky about certain syntactical issues (particular JOIN parentheses).
That said, I don't really miss that in Access, because I don't spend a great deal of time in the SQL view. Most of the queries I write can be done using the regular design view of the QBE grid. It's only when I need to do derived-table subqueries or UNIONs or non-equi JOINs that I have to dip into SQL view, and that's just not that often.
If you're starting from SQL view, then you're simply mis-using Access. You should be happy to not have to hand-write most of your SQL.
David-W-Fenton
2010-09-18 20:38:35
All that said, it sure is nice that A2007 finally added the capability to choose the font face and size. It's not much, but it's sure a huge improvement over the minuscule font size hardwired into A2000-2003.
David-W-Fenton
2010-09-19 20:56:18
From the Access 2003 main menu, Tools->Options, then selecting the "Tables/Queries" tab allows me to set both font name and size under "Query design font". That setting affects both design and SQL views.
HansUp
2010-09-20 23:57:35
Well, waddaya know! I thought that was only introduced in A2007! I basically skipped with a whole bunch of projects from A97 to A2003, with quite a bit of work in between using A2000, so I probably never thought to check something like that in A2003.
David-W-Fenton
2010-09-22 02:59:37