It is available in the Microsoft 365 update for Microsoft Office. It should update you to Version 2410 or higher (check File > Account > About Access). Then you should see the editor when you design a query and go to SQL view. If you don't see it, you can go File > Options > Current Database > Enable Monaco SQL Editor Enjoy!
You just need to install the latest version of Office 365 to get the new editor. I talk about the new editor and version at 0:49 in the video (you can see the minimum version that get the editor). Pretty nice addition, isn't it?
As far as I know, it is only available in Office 365, in the "Current Version" release. If you're stuck on 2021 or earlier and still need a good editor, I would recommend the free Notepad++ which you can see I use in other videos for simple editing. Just set the language to SQL and it will do all the highlighting for you.
Thanks Sean. That sort of query comes up every now and then. And Monaco is very good 👍
I'm happy that the SQL editor is being replaced/augmented. Long overdue and this seems to the job nicely!
Thank you very much Sean - another wonderful video.
Thanks!
Appreciate this. Thanks!
My pleasure! Glad it helped.
Any word when they are going to extend the Monaco Editor for VBA?
That's a good question. I don't know the answer to that one. If any viewers know this, please comment!
Thank u Sean, but how could I get beautiful sql view be like yours in videos?
It is available in the Microsoft 365 update for Microsoft Office. It should update you to Version 2410 or higher (check File > Account > About Access). Then you should see the editor when you design a query and go to SQL view. If you don't see it, you can go File > Options > Current Database > Enable Monaco SQL Editor
Enjoy!
In which version MS Office it is available
Good morning
But how did the sql editor appear to you like that?
You just need to install the latest version of Office 365 to get the new editor. I talk about the new editor and version at 0:49 in the video (you can see the minimum version that get the editor). Pretty nice addition, isn't it?
Editor is something new for me
🔧🧜🏻♀️🧜🏻alias
It is a new feature in Access! You need to update to the current version (2410) to get the editor (if you didn't already)
I have MS Office 2021
how can I get the new SQL Editor in Access?
As far as I know, it is only available in Office 365, in the "Current Version" release. If you're stuck on 2021 or earlier and still need a good editor, I would recommend the free Notepad++ which you can see I use in other videos for simple editing. Just set the language to SQL and it will do all the highlighting for you.
@seanmackenziedataengineering
thank you!! I appreciate it🙏