The Access SQL Editor mentioned earlier seems to work OK with MS ACCESS , it works well as it integrates with the existing MS ACCESS file and shows all existing queries.
However , I am worried if it is supported by Microsoft or not ?
I do a lot of development on MS ACCESS, but the interface for writing text SQL queries is very simple....are you talking about the ms Access QBE interface that looks like this:
it works well as it integrates with the existing MS ACCESS file and shows all existing queries.In its most basic sense, The QBE grid displays one query at a time.
What do you mean by "the interface for writing text SQL queries is very simple". Why is that bad in this case? Are you trying to edit Access SQL queries in a text content? Why not just switch your query to SQL View?