teslam2

sorry, i did not have time yet to try this on a new database with imported table. And yes after legacy sort order i did "compact and repair", i will check which sort order original database uses.

sorry, i did not have time yet to try this on a new database with imported table. And yes after legacy sort order i did "compact and repair", i will the which sort order original database uses.

This is my db - some data has spaces in first column... Column in question is also the primary key and it is indexed, check attachment Im just trying to change some dates in the table, it works fine when i update the row that has no spaces in the problematic column, but it corrupts the database if a row with space is updated... Using Access 2013, and jackess-2.2.3 ( need to be java 1.7 compatible...) Also i needed to set the database sort order in access to general-legacy, else it was opened readonly...

I have a weird problem... When trying to update a row using updateRow() with a value-string which has space at the end, mdb file gets corrupted on that row. Any rows in mdb that have a value ending with space, get corrupted when updating... Simple example, trying to put in a string with space as last char: Database db = DatabaseBuilder.open(file); Table someTable = db.getTable("tableName"); for (Row row : someTable) { //iterate trough all rows String value = row.getString("someColumn"); //get value...

I have a weird problem... When trying to update a row using updateRow() with a value-string which has space at the end, mdb file gets corrupted on that row. Any rows in mdb that have a value ending with space, get corrupted when updating... Simple example, trying to put in a string with space as last char: Database db = DatabaseBuilder.open(file); Table someTable = db.getTable("tableName"); for (Row row : someTable) { //iterate trough all rows String value = row.getString("someColumn"); //get value...