Manipulate Access databases through an intuitive JDBC driver which can select, insert, delete, and export logs of data, or execute SQL queries.
- UCanAccess
- Version : 4.0.2
- License :Apache License 2.0
- OS :Windows All
- Publisher :Marco Amadei
UCanAccess Description
Databases help store various information for different services, but one can also be used for personal interest. In any case, there are some specialized platforms that empower database usage, and with lightweight tools like UCanAccess, developers can easily manipulate data from Access databases and blend with Oracle.
Lightweight and easy to use
It can be used directly from a USB flash drive since it doesn’t require installation to run. However, proper functionality is ensured only if Java Runtime Environment is on the PC you want to use it on. Registries remain intact, so the target computer’s health status doesn’t suffer or get damaged.
Although UCanAccess is a command line utility, it doesn’t need to be launched from the Command Prompt. Sure enough, you work in such an environment with descriptions along the way so you know what’s next. What’s more, commands are similar to those of Oracle databases, so experienced individuals don’t have much trouble figuring things out.
Manipulate Access databases and export logs
The first things that needs to be done is to load a database file, which needs to be either a MDB or ACCDB Access file. The only way this is possible is by writing down the full path and file name. Once done, the table loads, with keys and columns shown in a large list.
There are quite a variety of operations you can perform, and, as mentioned above, commands work just like in an Oracle database, since the application is a JDBC driver. As such, you’re able to select, insert, remove, update statements, or execute custom SQL queries or commands.
Note that every command needs to end in a semicolon ( ; ) for a statement to function. Processing is done in real time, with the possibility to have results exported under a custom CSV file to better view changes, or simply keep a log of things.
A few last words
To sum it up, UCanAccess is a practical database management assistant which provide flexibility when having to deal with info from different types of databases, such as Access and Oracle. Although it might not appeal to the majority of the public because of the command line interface, enthusiasts and experienced individuals quickly get the hang of things because of simplicity of functions and triggers.