Provide a better SQL editor
Please provide a better SQL editor with syntax highlighting, indention, IntelliSense and using SQL comments in Access 2017.
At this point there is no plan to enhance Access SQL editor.
Please continue to use your votes.
ok heres my comment:Please provide a better SQL editor with syntax highlighting, indention, IntelliSense and using SQL comments in Access 2017.
This is one I use quite a bit
Andreas Neumann commented
Here is one more useful tool for SQL code formatting, which helps me to make my code more readable and beautifies SQL statements instantly and convert code into well formatted script.
"No Current Plan" !!! that is so... so... sad, frustrating, disheartening... the current editor is so bad ... A lot of other "ideas" posted for improvements are a subset or variation of this request....
Simply answering "No Current Plan"... I feel like I'm oblivious while on a sinking boat, ...
and I agree with wilo (June 02, 2016 09:12), simply keeping from destroying the formatting (indentation, removal of "extra" parenthesis, etc) would have been a good start.
At the very least Access should show a warning before messing things up (Ex.: Saving while in datasheet view/Opening the design window will reset formatting of the query text. Do you want to continue? Ok CANCEL)
Mark Burns commented
"No Current Plan"??! This is VERY Disappointing news, indeed!
David Peel commented
As far as I can see, there is no plan at all for desktop Access from Microsoft!
The only new features added to Access since 2007 are to support web databases in whatever the current flavour that MS has decided would be a good idea this year.
Ben Sacheri commented
I would like to recommend you look at the "Access SQL Editor" add-in from Field Effect, LLC which supports:
◾Search-and-replace, with regular expression support
◾Poor Man's SQL Formatter integration
◾Free trial. Full license is only $5.
(I am a user, not the author)
Sam Smith commented
That's a shame as the SQL editor is the heart of what we do. Enhancing it seems like a great idea as at present it is just a 'dead' text entry box. A missed opportunity.
Moshe Arzt commented
fantastic addin available here (I am a user, not the designer)
simply keeping the Format would be a very good improvement
I use Notepad ++ where you can specify the language of the document.
Available Language are SQL & Visual Basic and many more
John Partyka commented
Even Notepad has a search/replace capability.
Now, it is just like plain Notepad and we have to depend on third party tools (like http://poorsql.com/ and its tools) for formatting and syntax coloring
For a long time i was looking for a place where I can contact Microsoft regarding IntelliSense in the SQL editor of Access queries, finally I found it. I think it's long overdue.
most important to me is ZOOM ... my eyes cannot read as well as they used to. I often have to copy SQL to Word just to read it because it is too small for me. I put a lot of SQL into Word anyway as I wrote a function to format it and there I can also search/replace -- would be nice if the SQL statement would be saved as formatted.
Rather than revamping Access to be a word processor, how about if Word could be used as the editor?
Preserve text indentation, etc.
Find & Replace
Better support for Union Queries
Better support for SubQueries
One version for the user to work with and a minimized/compiled version for Access to run is what I'm assuming needs to happen
Including a separate font setting for the SQL code. Now the same font setting is shared between de grid designer and the SQL code editor. And add some color settings as well. Not just 16 colors like in VBE. That's really 90's.
[Deleted User] commented
Oh yeah... the Access SQL Editor is worse than Notepad! How about throwing in the ability to script in T-SQL as well? The Access SQL Editor has always been so bad... I don't think anyone has ever taken the time to actually learn the flavor of Access SQL... I imagine most of us interested in this option would be mostly familiar with T-SQL
Heinz Hoegel commented
This is one of my favorite suggestions for developers for decades now (literally)! Maybe this time MS will listen...
Alex Dybenko commented
At least search and replace, please...