Stack Overflow
Stack Overflow

Questions tagged [jackcess]

Jackcess is a pure Java library for reading from and writing to MS Access databases

Jackcess is a Java library providing read/write support for Access database versions 2000 through 2010(+), and read-only support for Access 97 files.

It provides interfaces to open an existing database, iterate over contained tables and read information from the rows in the table. It also allows to create new tables and populate data in them.

Additionally it has functionality to import data from and sources. Separately available extensions allow to read encrypted files.

130 questions
0
votes
2 answers

Jackcess Numberformatexception

I'm trying to create a program which takes input from a CSV-file and writes it to a Java-created Access database and table. The program uses a while-loop to go through the CSV-file. The first line of the file is written perfectly to the database,…
HaroldFinch
  • 31
  • 7
0
votes
0 answers

error : given file does not exist : dictionary

I added my dictionary.accdb file under res/raw and res directories though I'am getting given file does not exist : dictionary…
saigopi.me
  • 14,011
  • 2
  • 83
  • 54
0
votes
2 answers

Using Jackcess Encrypt causes "NoClassDefFoundError" exception for Cobertura

I'm trying to read a mdb file with jet encode with a very simple program. import java.io.File; import java.io.IOException; import com.healthmarketscience.jackcess.CryptCodecProvider; import com.healthmarketscience.jackcess.Database; import…
Jaime Acevedo
  • 1
  • 1
0
votes
0 answers

Reading encrypted Access .mdb using Jackcess throwing code coverage exceptions

I am trying to read a encrypted Access .mdb using the following libraries: Jackcess-2.1.6 Jackcess-encrypt-2.1.2 Ucanaccess-4.0.2 bcprov-jdk15on-157 While simply implementing the JackcessOpenerInterface as per Ucanaccess's documentation: public…
Hrafn
  • 2,867
  • 3
  • 25
  • 44
0
votes
0 answers

How to check username and password from only it's own row in MS Access? [Jackcess]

This is my database creation using jackcess: try{ if(!f.exists()){ Database db=DatabaseBuilder.create(Database.FileFormat.V2000,new File(file)); Table table=new…
MrBlock2274
  • 19
  • 7
0
votes
2 answers

Read an Access database which uses linked tables with Excel sheets

I am trying to read data from an Access database using the Java library Jackcess. The database has several tables and queries, some of which are linked tables pointing to Excel sheets on the file-system. I saw that I can use a LinkResolver to…
centic
  • 15,565
  • 9
  • 68
  • 125
0
votes
1 answer

How do I check email address and password in Java using Jackcess?

I wish to create login page which uses Email Address and Password as log in details. Is there anyway to do this using Jackcess? I am avoiding ucanaccess method because it keeps giving me SQL exception error. Here's the code for sign in…
MrBlock2274
  • 19
  • 7
0
votes
1 answer

UCanAccess upgrade Apache Commons Lang version

Can you upgrade your Apache Commons Lang 2.6 to Apache Commons Lang 3.5 ? See https://commons.apache.org/proper/commons-lang/download_lang.cgi .
jaktao
  • 3
  • 1
  • 2
0
votes
1 answer

jackcess - database pathname in databasebuilder.open

I have a Microsoft Access database called perso.accdb. I use the Jackcess library to try to open it using the following code taken from official documentation here Database db = DatabaseBuilder.open(new File("mydb.mdb")); Sounds simple enough, but…
kgromeo
  • 3
  • 1
0
votes
0 answers

Jackcess from R using rJava in OSX

I tried all the suggestions in this related question and still get the last error library(rJava) .jinit(force.init = T) .jaddClassPath(dir('~/Dropbox/R_packages/JavaJS/',full.names = TRUE))) mol.db <- "~/Downloads/SEPULVEDA_MOLECULAR.accdb" jfile =…
Jorge Sepulveda
  • 291
  • 2
  • 8
0
votes
1 answer

jdbc/Jackcess/Ucanaccess - Not able to connect to access tables linked to sharepoint list

I have been trying to connect to access database on my local machine using jackcess/ucanaccess. This database is linked with sharepoint list. The connection happens and I can read from the tables. When I remove link to the sharepoint list for one of…
Sameer
  • 1
0
votes
1 answer

Jackcess Table Limit?

I'm currently trying to resolve an issue related to a program written by someone else that uses Jackcess version 1.1.8 to write information out to an Access database. In a run which should add 4 million rows to a given Access table, the following…
Sheldon R.
  • 452
  • 2
  • 7
  • 26
0
votes
1 answer

Ms Access makes database read-only and couldn't be updated with Java

I have in my project a Ms Access database which worked fine before, now after formatting my computer I've run my project and It worked but when I opened the database with MsAccess 2007 and closed it. It won't get updated with the Java project. I…
Gregor Samsa
  • 115
  • 12
0
votes
1 answer

Ucanaccess JDBC Driver - outofmemory error with memory=false setting

I am using jackcess-2.1.1. I have set the memory=false parameter, but still face the outOfmemory Error. It happens while processing a MDB file of 1.8GB size. The JVM memory arguments are set to 1GB max size. If I change the Max size to 2GB, it works…
Leela Addagulla
  • 181
  • 1
  • 1
  • 10
0
votes
1 answer

Unable to drop table via Jackcess using getSystemTable and findFirstRow

Why can't cursor findFirstRow when I try to use Jackcess to find the row that I need to delete in order to drop a table? private static void deleteTable(Database db, String tableName) throws IOException { Table table =…
BugKiller
  • 94
  • 1
  • 10
1 2 3
…
8 9