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

447 questions
-1
votes
1 answer

Ucanaccess throwing exception

When I am trying to fetch data from access database ucanaccess driver is throwing this exception net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.4 data type cast needed for parameter or null literal here is the screen of my application…
Danial Ghani Attari Qadri
  • 1
-1
votes
1 answer

java ucanaccess data storing

i tried to store in two column current data and time on my microsft access database from java, but when i open my file no data has been stored. I tried to print the columns but it print "null". How can i do? Date date = new Date(); final String…
Miriam Younes
  • 1
  • 4
-1
votes
1 answer

"No suitable driver found" for UCanAccess connection

I have no idea what wrong is with my sample code, I've followed all instructions on multiple YouTube videos and other online sources. I just can't fix it. Could someone explain what is the problem and how to solve it? All the required lib's are…
Esme van Stryp
  • 1
  • 2
-1
votes
1 answer

java - ResultSet displaying as String

I am using the ucanaccess tool to interact with my access database, but I do not know how to display or store the resulting ResultSets as Strings. Edit: I have tried =System.out.println(resultSetId.getString(1)); but that only returns errors. …
Edward Pearce
  • 3
  • 2
-1
votes
1 answer

No suitable driver found for jdbc:ucanaccess: i got this error when i try connect to Ms access database

I trying to get data from ms access database stored in Azure File Storage. I set right path to storage, but when I try to get data from base I got this error.My application work fine when ms access database is on my machine. This is my…
Triso
  • 25
  • 9
-1
votes
1 answer

Open command console and pass arguments into it using VBA Access

I have this: Private Sub Command25_Click() Dim BatFile As String BatFile = "C:\UCanAccess-4.0.2-bin\console.bat" Shell BatFile & " " & """C:\Users\celso\Documents\KeysConsole.accdb""" What I want is to use UCanAccess to connect to my…
Celso
  • 1
  • 1
-1
votes
1 answer

Retrieving primary key information with UCanAccess

I'm trying to get all database metadata from an Access database using the UCanAccess JDBC driver but I need to change my resultset type to navigate in the resultset but how to set the good type when my resultset are created with method from the…
kazor02x
  • 43
  • 1
  • 8
-1
votes
1 answer

Cannot insert values into access 97 using Ucanaccess 3.0.6. It shows access is read only

Cannot insert values into access 97 using Ucanaccess 3.0.6. It shows access is read only. Error: UCAExc:::3.0.6 Access 97 is supported in read-only. Is there any solution for inserting values to access 97 db in java.
Brahma Dutt Sudhakaran
  • 11
  • 5
-1
votes
2 answers

UCAExc 3.0.7 unexpected token Errors

I'm working on a project that wants me to integrate a Microsoft Access database into a Java program. I have successfully connected to the database however my SQL statements are not updating the DB. I have defined variables that read user input and…
ace7
  • 71
  • 1
  • 2
  • 6
-1
votes
1 answer

UCanAccess - Mirror Folder files are not being recreated when Access database is changed by another program

Mirror Folder files are not being recreated when Access database is changed by another program. The below is my connection string: jdbc:ucanaccess://E:\db\CostData.accdb;memory=false;keepMirror=C:\Users\Nader…
Youssef
  • 1
-1
votes
2 answers

when we create table directly from java in ms access,"Null" occurs

when i create table directly from java in ms access,"Null" occurs.What is meant by this
Mcolo
  • 149
  • 2
  • 10
-1
votes
2 answers

parameter marker not allowed (updating Access database)

Statement st = connect.createStatement(); String sql = "update StudentDatabaseS set RollNo = ?, FullName = ?, FatherName = ?, FatherCNIC = ?, DateOfBirth = ?, Class = ?, Address = ?, City = ?, Province = ? where RollNo = '"+Srollno+"'"; ResultSet rs…
Abdul Wahab
  • 89
  • 1
  • 9
-1
votes
1 answer

Database query not working in JAVA

I'm editing a library management system in JAVA and I'm having problems with the search functions. Each book has a BookID, Subject, Title, Author, etc and each member has a MemberID, Name, etc. If I select the search to be by Subject, or Title or…
El Dj
  • 355
  • 2
  • 17
-1
votes
1 answer

Connecting to an Access database on Tomcat

Trying to put a .mdb file on tomcat and access it. It worked locally, but after trying to deploy it to a local tomcat server it throws an exception. This is the line that is raising an error : Connection dbConnection =…
UserED
  • 33
  • 9
-1
votes
1 answer

UCanAccess UPDATE statement exception: "Unexpected page type 1"

Using Java with MS Access database, adding and selecting data is working just fine, but for some reason I can't update, it keeps throwing an exception net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.2 Unexpected page type 1 I've never…
Abdullah Asendar
  • 485
  • 1
  • 5
  • 24
1 2 3
…
29
30