Is there an ACCESS 2007 JET SQL editor or client (not sure the right term is) that can be used to code Access Jet SQL queries? It is very difficult to write SQL queries in ACCESS 2007 since it's like basically typing in notepad without any special text formatting for keywords or commands for example. Its hard to write and read... Any suggestions or tools that I can use to make this process easier?

  • the only other alternative I have come up with is using Word and then copying and pasting into Access Sql Window...
    – Juan Velez
    Commented Jun 27, 2012 at 20:06
  • 2
    No, no, no, not Word. Word is not a code editor, it's a (rich) format editor. It wasn't designed for code editing. Commented Jun 28, 2012 at 7:16

2 Answers 2


There are many tools and ways better ways to do SQL editing for Access 2007 other then using msword , at least i would use Notepad++

below are tools i used and are good

  1. RazorSQL
  2. SQuirreL SQL

here is a 2 post1 and post2 in Stackoverflow similar to your issue

but if you want my opinion to this problem, the best thing i suggest is to use SSMS and add a linked server to your Access file, i like SSMS


I realize this question is over 3 years old now, but I wrote an MS-Access add-in called Access SQL Editor (link), because I write a lot of SQL in Access.

It's not free, but it's very inexpensive. If you find it useful but can't afford it, or you really don't want to buy it, contact me and I'll send you a free license.


  • Syntax Highlighting
  • SQL Comments
  • Line numbers
  • Search-and-replace, with regular expression syntax
  • Hotkeys
  • Automatic query formatting
  • Supports pass-through queries
  • Works with Access 2002-2016 (it's activated from the "Add-Ins" menu in Access)
  • This should be the accepted answer. I tried both application from the accepted answer and this add-in is by far better.
    – jotapdiez
    Commented Oct 26, 2017 at 13:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.