Provide a better SQL editor
Please provide a better SQL editor with syntax highlighting, indention, IntelliSense and using SQL comments in Access 2017.
Daniel Schunk
shared this idea
The Access team is adjusting our status for this request – we are planning to embed the Monaco Editor (support for SQL Editor improvements) into Access, to be released within the next semester (first half of 2021), which will provide capabilities such as syntax highlighting, IntelliSense, SQL comments, and more. We are excited to have this capability released by next year, and we appreciate the energy and enthusiasm on this feature request. We still have a long ways to go to improve our experience with SQL, so please stay tuned as we execute on this objective!
Thanks,
Ebo [MSFT[
25 comments
-
Andrew
commented
Any update on this release?
-
The Access team is adjusting our status for this request - we are planning to embed the Monaco Editor (support for SQL Editor improvements) into Access, to be released within the next semester (first half of 2021), which will provide capabilities such as syntax highlighting, IntelliSense, SQL comments, and more. We are excited to have this capability released by next year, and we appreciate the energy and enthusiasm on this feature request. We still have a long ways to go to improve our experience with SQL, so please stay tuned as we execute on this objective!
Thanks,
Ebo [MSFT[(Edited by admin) -
melanie1
commented
ok heres my comment:Please provide a better SQL editor with syntax highlighting, indention, IntelliSense and using SQL comments in Access 2017.
-
pflipper
commented
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.
http://sql-format.com/ -
Anonymous
commented
"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:
◾Syntax Highlighting
◾Comments
◾Line numbers
◾Search-and-replace, with regular expression support
◾Poor Man's SQL Formatter integration
◾Free trial. Full license is only $5.http://fieldeffect.info/wp/access-sql-editor-documentation/
(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)
http://fieldeffect.info/wp/access-sql-editor-documentation/ -
wilo
commented
simply keeping the Format would be a very good improvement
-
LD
commented
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.
-
Anonymous
commented
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
-
Howard31
commented
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.
-
Crystal
commented
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?
-
[Deleted User]
commented
Preserve text indentation, etc.
Text Highlighting
Formatting
Find & Replace
Better support for Union Queries
Better support for SubQueries
inline commentsOne version for the user to work with and a minimized/compiled version for Access to run is what I'm assuming needs to happen
-
Anonymous
commented
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