RDD Open Source Software

JetSQLConsole

JetSQLConsole provides a simple command line/console interface for Microsoft Access databases. Structured query language (SQL) commands may be entered directly via the command line and executed against the selected Microsoft Access file (Jet SQL is the "dialect" of SQL supported by Microsoft Access). Query results are then displayed in text format in the console window. JetSQLConsole is designed to be very similar in appearance and operation to the widely used commandline-based MySQL client application.

JetSQLConsole is intended for database users and developers familiar with SQL, as an alternative to the more typical graphical approach to query design used in Microsoft Access. (While the Microsoft Access interface supports text-based SQL queries, the process of using such a query can be inefficient, and users are limited to entering commands individually.) With JetSQLConsole, complex queries may be written and tested easily and efficiently. Lengthy datasets returned by these queries may be saved and manipulated as plain text in a wide variety of other applications. In addition to the standard command line interface, complex SQL/DDL commands or a lengthy series of commands from a plain text file may also be executed quite easily.

System requirements

JetSQLConsole is written for Microsoft Windows. It is known to run on Windows 2000 and Windows XP. The application should also run on Windows 98, ME, and NT 4. JetSQLConsole has not been tested with Windows Vista by the developers: if you are using JetSQLConsole with Windows Vista, we would like to hear from you!

   

---