UCanAccess icon

UCanAccess

4.8/5 13
Certified 100% FREE GPL   

Manipulate Access databases through an intuitive JDBC driver which can select, insert, delete, and export logs of data, or execute SQL queries. #Read Access  #MDB reader  #JDBC driver  #Reader  #JDBC  #Access  

Softpedia Review

specifications

changelog

Free Download

Review by:
4.0/5

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.

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.

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.

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.

Download Hubs

UCanAccess is part of these download collections: Open MDB

What's new in UCanAccess 5.0.1:

  • Fix updates failed in tables with Blob/Ole not null
  • Insert/Update of Blob/Ole objects in this simplified way: preparedStatement.setObject(1, new File("c:\<file path>"));
Read the full changelog
User Comments
This enables Disqus, Inc. to process some of your data. Disqus privacy policy

UCanAccess 5.0.1

add to watchlist add to download basket send us an update REPORT
PRICE: Free
  runs on:
Windows All
  file size:
3.2 MB
  filename:
UCanAccess-5.0.1-bin.zip
  1 screenshot:
UCanAccess - UCanAccess enables you to enter the path of the MDB file and load the database tables
  main category:
Programming
  developer:
  visit homepage