And there is still message: "Data type mismatch in criteria expression.".
long var = 1211292642734L; PreparedStatement ins = connection.prepareStatement("INSERT INTO linktable VALUES("+var+")"); ins.execute();
So perhaps LONG type in Access isn't the same as long type in JavaThe LONG data type in Access is equivalent to INTEGER4, 4 bytes: Java int (there is also a INTEGER2, equivalent to java char).
if yes: have you any idea how to save long type variable in database?See #1.