UCanAccess Icon

UCanAccess

A pure java JDBC Driver for MS Access

4.8 Stars (20)
1,191 Downloads (This Week)
Last Update:
Download UCanAccess-3.0.6-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

★★★★★
★★★★
★★★
★★
19
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

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

    Developers seem to be very motivated. Projects works, some things are not perfect yet, but it's much better than a few years ago.

    Posted 03/31/2016
  • 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Incredible project and very useful, Many thanks to the author !

    Posted 03/18/2016
  • 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    It's not perfect, but the creator is permanently looking to update his software, and helping the community with their problems. He diserves the 5 starts.

    Posted 01/21/2016
  • 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Works as advertised. Excellent help from the forums!

    Posted 12/07/2015
  • 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5

    Amazingly robust and full featured tool for working with Access files on non-Windows platforms.

    Posted 12/02/2015
Read more reviews

Additional Project Details

Languages

English

Programming Language

Java

Registered

2012-11-18

Thanks for helping keep SourceForge clean.

Screenshot instructions:
Windows
Mac
Red Hat Linux   Ubuntu

Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)

More information about our ad policies
X

Briefly describe the problem (required):

Upload screenshot of ad (required):
Select a file, or drag & drop file here.

Please provide the ad click URL, if possible:

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks
Screenshots can attract more users to your project.
Features can attract more users to your project.