Download
This JDBC interface serves as a full JAVA interface to MS Access files. 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.
License
GNU Library or Lesser General Public License version 2.0 (LGPLv2)Follow EnterAccess
nel_h2
Simply solve complex auth. Easy for devs to set up. Easy for non-devs to use.
Custom auth drains 25% of dev time and risks 62% more breaches, stalling enterprise deals. Frontegg platform delivers a simple login box, seamless authentication (SSO, MFA, passwordless), robust multi-tenancy, and a customizable Admin Portal. Integrate fast with the React SDK, meet compliance needs, and focus on innovation.
Rate This Project
Login To Rate This Project
User Reviews
-
We (UCanAccess) currently support the whole Access SQL(and something more) as well as advanced features, e.g. pivot queries, complex types and calculated fields. Limited DDL because of jackcess contraints about it. The main ORM libraries understand nicely the metadata we provide. So, why do you start with a comparison? Good luck!