Search Results for "ucanaccess"

UCanAccess is a pure Java JDBC Driver implementation which allows Java developers and JDBC client programs to read/write Microsoft Access database (.mdb and .accdb) files. No ODBC needed.

SQLeo is a professional lightweight SQL Query tool that permits to create or display complex sql queries (from OBIEE, Microstrategy, SSRS, Cognos, Hyperion, Pentaho ...) and permits to reverse engineer database models as db designers do. This SQL GUI supports all JDBC drivers: Oracle, MySQL, MSSQL, Firebird, HSQLDB, H2, PostgreSQL, CsvJdbc, SQLite, UCanAccess, MonetDB ... (but MySQL jdbc and CsvJdbc are the only driver included in the package) Can be compared with : FreeQueryBuilder (SQLeonardo ancestor), SQuirreL SQL, Active Query Builder, Flyspeed, Oracle SQL developer, Toad, DbVisualizer, MySQL Workbench, DBeaver, Aqua Data Studio ...

...It was developed to support the Software-Independent Archival of Relational Databases (SIARD) of the Swiss Federal Institute. It is based on the project Jackcess for accessing MS Access files and makes use of the project H2 for parsing SQL. It is an alternative to the JDBC interface UCanAccess, whose metadata and type support and very limited SQL for DDL and DML queries could not be adapted for the purposes of SIARD. Currently EnterAccess queries are limited to a single table. All DML and DDL queries are limited by the capabilities of Jackcess, which is good at reading a database and weak on creating a view, creating foreign keys, or modifying a schema.