UCanAccess Icon

UCanAccess

A pure java JDBC Driver for MS Access

4.7 Stars (14)
869 Downloads (This Week)
Last Update:
Download UCanAccess-3.0.0-bin.zip
Browse All Files
Windows Mac Linux

Screenshots

Description

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.

UCanAccess Web Site

Features

  • Supported Access formats: 2000, 2003, 2007, 2010.
  • SELECT, INSERT, UPDATE, DELETE statements. Transactions and savepoints.
  • Access data types: YESNO, BYTE, INTEGER, LONG, SINGLE, DOUBLE, NUMERIC, CURRENCY, COUNTER, TEXT, OLE, MEMO, GUID, DATETIME.
  • Concurrent access from multiple users (i.e., multiple application server threads).
  • Connection pooling.
  • ANSI 92 SQL, core SQL-2008.
  • MS Access SQL.
  • Main Access functions implementation.
  • You can execute select queries defined and saved in Access.
  • Criteria in LIKE clause.
  • Access date format (e.g., #11/22/2003 10:42:58 PM#).
  • Both double quote " and single quote ' as SQL string delimeters.
  • Command Line Console. You can run SQL commands and display their results. CSV export command.

KEEP ME UPDATED

User Ratings

★★★★★
★★★★
★★★
★★
13
0
0
0
1
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 4 / 5
Write a Review

User Reviews

  • hardoftware
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Following the instructions in askubuntu.com I managed to create a link to a local mdb. (I could see my tables) The problem is that after installing all these, every odb I opened, first time opened ok but after that became unusable. This is a strange behaviour since I did not saved the opened odb. So the jars provided did something to my LO or to the specific odb. After removing all files added to "class Path" (in Tools > Options > Advanced) The problem stopped for the unopened odbs but it was still present for the already opened and closed. ---- using UCanAccess-3.0.0 in ubuntu 14.04 64bit my odb files have a startup form. code Sub ShowMyStartupFrom( ) OpenMyForm("Ολα") End Sub Function OpenMyForm(frmName As String) As Object Dim ObjTypeWhat 'OpenMyForm = Null ObjTypeWhat = com.sun.star.sdb.application.DatabaseObject.FORM If ThisDatabaseDocument.FormDocuments.hasbyname(frmName) Then 'Check the form exists ThisDataBaseDocument.CurrentController.Connect() 'If the form exists connect to the database ThisDatabaseDocument.CurrentController.loadComponent(ObjTypeWhat, frmName, FALSE) 'Open the form OpenMyForm = ThisComponent Else Error1(frmName) End if End Function stops in connecting (ThisDataBaseDocument.CurrentController.Connect()) with an exception: com.sun.star.sdbc.SQLException

    Posted 08/28/2015
  • hartwigthomas
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Becomes even more important, as the old JDBC-ODBC bridge from SUN will not work under JAVA 8 any more.

    Posted 10/30/2014
  • nigelvthomas
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Great asset for programmatic access to Microsoft Access Databases.

    Posted 10/02/2014
  • robertino129
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Easy, supported, and features that do not exist can be requested and implemented which leads back to support.

    Posted 06/24/2014
  • gordonthompson
    1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    This was a wonderful discovery even before the demise of the JDBC-ODBC Bridge in Java 8. It is even more valuable now. THANKS!!

    Posted 04/18/2014
Read more reviews

Additional Project Details

Languages

English

Programming Language

Java

Registered

2012-11-18
Screenshots can attract more users to your project.
Features can attract more users to your project.