UCanAccess Icon

UCanAccess

A pure java JDBC Driver for MS Access

4.8 Stars (21)
965 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

See Who Has Access to What in Your AD and File Shares Icon

This new free tool helps IT admins discover and rescind unneeded access rights to ensure that all permissions align with HR job descriptions.

See Who Has Access to What in Your AD and File Shares Icon
The Netwrix Auditor Effective Permissions Reporting Tool enables you to quickly track down who has access to what across both AD and file servers, see how that access was gained, and get ready-to-use reports in a few clicks. It is free of charge and will never expire, so you can be sure it’ll be there for you when you need it most.
See Who Has Access to What in Your AD and File Shares
Are you an IT pro at a company with 250+ employees?

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.

No, thanks