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?
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
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