5

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.

Improve this question
2
  • Are you trying to ask a question or promote your own software ?
    – Bruce McLeod
    Jul 27, 2009 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, 2009 at 12:46

6 Answers 6

Reset to default
2

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

Improve this answer
1
  • I think I have a new favorite
    – Justin Dearing
    Sep 10, 2011 at 14:48
1

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.

Improve this answer
1
  • i like your naming convention :)
    – quack quixote
    Oct 14, 2009 at 22:03
1

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.

Improve this answer
1

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

Improve this answer
1
  • Marking this program as best of breed for now. If someone knows of a better program, let me know.
    – Justin Dearing
    Aug 17, 2009 at 13:39
0

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.

Improve this answer
1
0

MDBPlus works well and is able to open & edit very old Access databases.

Improve this answer

You must log in to answer this question.

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