free sql code editor?

Question

i am breaking my eyes trying to write sql code in ms access. is there a free editor out there?

Answer 1

SQL Server Management Studio Express

You should be able to use it as a SQL editor without SQL Server.

Answer 2

I normally use SQuirrel SQL Client to connect to just about any database I need to work with. You can use it with any database you can find a JDBC driver for.

Answer 3

I haven't tried it yet, but I believe they improved the editor in Access 2010 . Here's a post from the Access Blog that discuss IntelliSense.

Answer 4

OraEdit

http://www.dkgas.com/oraedit.htm

Microsoft® SQL Server® 2008 Management Studio Express

http://www.microsoft.com/downloads/details.aspx?FamilyID=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en

MS SQL Code Factory

http://www.sqlmaestro.com/products/mssql/codefactory/

DatabaseSpy SQL Editor

http://www.altova.com/databasespy/sql-editor.html

SQuirrel SQL Client

http://squirrel-sql.sourceforge.net/index.php?page=screenshots