Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

5 Answers

up vote 1 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
add comment

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
add comment

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
add comment

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
add comment

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
add comment

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.