Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

A few years ago I was developing a .NET application for a client that used Microsoft Access. Regardless of the merits of this technical decision, I ended up writing my own query editor for Microsft Access and SQLite files.

I have since found out I was not the only one to do so.

Please, one program per answer.

share|improve this question
Are you trying to ask a question or promote your own software ? – Bruce McLeod Jul 27 '09 at 11:08
Bruce, Actually, I'd like to use something else now that I know better things exist. Unfortunately, there seems to be a lack of interest in a propry SQL editor for MS Access. That being said, I want this list to be as exhaustive as possible, and therefor it includes my program. – Justin Dearing Jul 27 '09 at 12:46
up vote 2 down vote accepted

Oracle SQL developer works as well. It also connects to Oracle, MySql (no surprises) SQL Server, Sybase and DB2. See Database Connections on the feature list

share|improve this answer
I think I have a new favorite – Justin Dearing Sep 10 '11 at 14:48

PlaneDisaster.NET Is the program I wrote to accomplish this task. The user interface leaves a lot to be desired, but it got the job done.

share|improve this answer
i like your naming convention :) – quack quixote Oct 14 '09 at 22:03

JetSQL Console is an open source command line only console app. Its written in QT, despite having no GUI. Its not very polished, but lets you manipulate MDB files via the command line.

share|improve this answer

Yes another open source gui app for doing this is MS Access Databases Queries Editor. It has a better looking GUI than PlaneDisaster.NET.

share|improve this answer
Marking this program as best of breed for now. If someone knows of a better program, let me know. – Justin Dearing Aug 17 '09 at 13:39

Sometimes I use AnySQL Maestro. The free version targes anything with an OLEDB driver.

Similarly you can use free JDBC tools + ODBC drivers to target MS-Access (as a generic JDBC/ODBC) database, although I haven't tried this for a long time so I'm not sure what exists now-a-days.

share|improve this answer
I will check out Maestro. – Justin Dearing Sep 15 '09 at 13:17

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .