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.

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.

Project Samples

Project Activity

See All Activity >

Follow UCanAccess

UCanAccess Web Site

Other Useful Business Software

WhatsUp® Gold - Start A Free 30-Day Trial WhatsUp® Gold - Start A Free 30-Day Trial Icon
WhatsUp® Gold - Start A Free 30-Day Trial Icon

All-in-one monitoring of your entire infrastructure with the industry's most user friendly pricing. Free trial of our award-winning software

If you are like the rest of our user community, your IT team is busy. With pressure to deliver on-time projects, you don’t have a lot of time to spend making your management tools work. You need network monitoring tools that work for you. You want tools that makes it easy to find performance issues before your users do and resolve them before they impact the business. That’s why tens of thousands of customers around the world love WhatsUp Gold.
1/2
How many devices do you monitor on your company's network?
2/2
One last question before you visit our site:

When do you plan to purchase a network performance monitoring solution?

Rate This Project

Login To Rate This Project

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

User Reviews

  • 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!

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

    1 user found this review helpful.
  • Incredible project and very useful, Many thanks to the author !

  • 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.

    1 user found this review helpful.
  • Works as advertised. Excellent help from the forums!

Read more reviews >

Additional Project Details

Languages

English

Programming Language

Java

Database Environment

JDBC

Registered

2012-11-18