Stack Overflow
Stack Overflow

Questions tagged [ucanaccess]

UCanAccess is a pure Java JDBC driver that allows us to read from and write to Microsoft Access databases without using ODBC.

UCanAccess is a pure Java JDBC driver that allows us to read from and write to Microsoft Access databases without using ODBC. It provides a cross-platform alternative to using the JDBC-ODBC Bridge (which has been removed from Java SE 8 and is not supported).

470 questions
2
votes
1 answer

Java: ucanaccess hsqldb java.lang.NoSuchMethodError:

I downloaded and installed the uCanAccess jars by following instructions from here: Manipulating an Access database from Java without ODBC I'm learning how to use the microsoft access db for java and this is the coding I used package…
Recto7299
  • 23
  • 5
2
votes
2 answers

Unable to execute update statement in ucanaccess

I have a connection to a Microsoft Access database. Once I make the connection I'm trying to get everything from that table I'm accessing with the following query. ResultSet rSet = stmt.executeQuery("Select * FROM DraftNightQuery") As far as I am…
AndyReifman
  • 1,459
  • 4
  • 18
  • 34
2
votes
1 answer

User lacks privilege or Object not found error for saved query

With Java 8 not supporting JDBC I'm attempting to modify my program so it can still pull and modify data from a Microsoft Access database. It keeps throwing an SQLException. Currently this is what my code looks like for opening a connection to the…
AndyReifman
  • 1,459
  • 4
  • 18
  • 34
2
votes
1 answer

Connect to encrypted Access database using UCanAccess

How can you create a connection to an encrypted Access database using UCanAccess? import net.ucanaccess.jdbc.UcanaccessDriver; Class.forName("net.ucanaccess.jdbc.UcanaccessDriver"); conn=DriverManager.getConnection("jdbc:ucanaccess://" + sample+…
Jay Boysample
  • 21
  • 2
2
votes
1 answer

UCanAccess "User lacks privilege or object not found" error on opening database

I have a Java program that needs to pull from a Microsoft Access database. I recently had to change the code to use UCanAccess instead of ODBC as the JDBC-ODBC Bridge is not supported in Java SE 8 (Manipulating an Access database from Java without…
user3656992
  • 143
  • 1
  • 9
2
votes
2 answers

Error connecting Java 8 with Access: No suitable driver found

I want to connect Java 8 with Access but the following error occurs and I don't know how to fix it. I always get this error: java.sql.SQLException: No suitable driver found for jdbc:ucanaccess://C:/Users/Ghazi/workspace/java w…
user3000000
  • 35
  • 1
  • 1
  • 7
2
votes
2 answers

importing data from csv file into access database using java

I need to import csv into access database using java. I tried using the following code my code: public static void main (String args[]) { String dbFileSpec = "C:\\Documents and Settings\\admin\\My…
Dhinakar
  • 4,061
  • 6
  • 36
  • 68
2
votes
2 answers

net.ucanaccess.jdbc.UcanaccessSQLException: Column not found: 0

I am new for UCanAccess package checktpsystemdatabase; import java.sql.*; public class CheckTPSystemDatabase { public static void main(String[] args) throws SQLException { try { Connection con =…
Dragon Warrior
  • 307
  • 3
  • 16
2
votes
1 answer

ucanaccess is overloading the system, What to do?

The idea behind my app is to banish client's direct access to my database (which is in .mdb format) by downloading the whole .mdb file to the client side , recording changes done by them and uploading those changes once per day for each client. The…
Rahmoune Med El-habib
  • 31
  • 7
2
votes
1 answer

How to create relationship between two tables with UCanAccess?

I create two tables with relationship between them with UCanAccess. But it doesnt create the relationship. Why? What is wrong? How can i solve this problem? statement.execute("CREATE TABLE example1 (ExId LONG PRIMARY KEY, Title TEXT)…
Viktor Verebélyi
  • 23
  • 2
2
votes
1 answer

Workaround in UCanAccess for multi-value fields: "incompatible data type in conversion: from SQL type OTHER"?

I am trying to use UCanAccess to query a MS Access .accdb file. Everything works great, except when I query multi-value fields. For example those that have entries in the Row Source of a table field's Lookup tab in design view in MS Access. My…
thayer
  • 80
  • 1
  • 7
2
votes
1 answer

Java UCanAccess doesn't detect all items

I have a problem. I use this query: SELECT prodeje.datum, prodeje.prodejce, prodeje.pocet, prodeje.cena, produkty.autor_music, produkty.autor_text, produkty.skladba, produkty.isrc, …
Tomááš Šediivý
  • 23
  • 5
1
vote
2 answers

Count record with two criteria in unbound textbox

i have fields named "Date of Payment" and "Type of Application". i have also unbound textbox with a name "txtCount". i want to display in "txtCount" the total count of records if "Date of Payment" = year 2022 AND "Type of Application" = "New…
Kier Arts
  • 21
  • 3
1
vote
2 answers

UCanAccess keeps repeating column names as data

I was using UcanAccess 5.0.1 in databricks 9.1LTS (Spark 3.1.2, Scala 2.1.2), and for whatever reasons when I use the following code to read in a single record Access db table it keeps treating the column names as the record itself (I've tried…
Alex Wong
  • 11
  • 2
1
vote
0 answers

How do I use JayDeBeApi to read a Access DB file on Databricks?

Currently trying to use the JayDeBeApi pkg with Ucanaccess drivers to read an .accdb file on Databricks. I am placing the .accdb file in the DBFS and trying to read from there. I am currently using Databricks Community Edition to build a proof of…
Leland Adams
  • 11
  • 2
1 2 3
…
31 32