Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

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?

share|improve this question
the only other alternative I have come up with is using Word and then copying and pasting into Access Sql Window... – JuanVelez Jun 27 '12 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. – ypercube Jun 28 '12 at 7:16
lol! got it. thanks! – JuanVelez Jun 28 '12 at 14:20

1 Answer

up vote 3 down vote accepted

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

share|improve this answer
1  
Awsome thanks! I will try that! – JuanVelez Jun 28 '12 at 14:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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