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

UCAExc:::3.0.7 user lacks privilege or object not found: SLIPSET

I have looked through similar threads on this site and none of the suggested answers seem to work. I am writing a java program that interacts with an Access database using SQL. I have successfully connected to the database and pulled information…
ace7
  • 71
  • 1
  • 2
  • 6
-2
votes
1 answer

Cannot Delete a record with an delete query though Java Eclipse connected to MS Access

Problem with delete record in MS Access. It show this error when print stack trace net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::3.0.1 user lacks privilege or object not found: PHONE at…
-2
votes
1 answer

Using UCanAccess to read excel sheet instead of JDBC-ODBC Bridge

I tried to upgrade my server JVM to java 8 but I was surprised that Oracle has removed JDBC ODBC bridge from Java 8 ! I searched for alternatives and I found people here provide another solution by a library called UCanAccess but it's mainly for…
A. Shaheen
  • 105
  • 13
-2
votes
1 answer

Connect to Access database protected with database password using UCanAccess

I can connect to an Access database with UCanAccess from NetBeans 8, but now I need to specify database password in the connection properties. How can I do that?
ChemaPando
  • 1
  • 1
  • 2
-4
votes
1 answer

UCAExc:::4.0.4 attempt to assign to non-updatable column

This is a link to a sample database I would like this code to connect to my database and encrypt the rows within the table "WellTable" unfortunately I am getting an error listed below. I have followed the guide here: Manipulating an Access database…
1 2 3
31
32