UCanAccess Icon

UCanAccess

A pure java JDBC Driver for MS Access

4.8 Stars (21)
856 Downloads (This Week)
Last Update:
Download UCanAccess-4.0.2-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

Other Useful Business Software

Resolve IT tickets faster with Snagit Icon

Snagit® - Powerful Screen Capture and Screen Recorder Software - Winner of G2 Crowd Best Software for Business Operations Teams 2017

Resolve IT tickets faster with Snagit Icon
Snagit’s image and video capture is powerful, but not complex. All-in-One Capture® grabs your entire desktop, a region, a window, or a scrolling window from any webpage or application—-all with a single hotkey or click. Snagit gives you a simple way to edit. Show a complex process, give detailed feedback, or share important information with the people who need it most. Download your free trial now!

User Ratings

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

    Really useful project, if you need to use MS Access databases; some important feature is not present yet, but people involved in the project are always quick and helpful on the forum. Thanks to these people!

    Posted 08/05/2016
  • 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
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:

JavaScript is required for this form.

No, thanks