MS Acces Error Could not update; currently locked by user
posted 11 years ago
I am getting the below exception, when I try to update a record in MS-Access database. Its a desktop application that does the update in MS-Access.
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Could not update; currently locked by user 'admin' on machine 'ZCHQ_B2B'. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source) at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source)
This error does not occur in all systems, it has happened in just one system and I am not able to re-create this error in my system. Both the systems are Windows 2K with service pack 4.
I suspect either the driver or could be because that we use two different DBConnection and Process to update the same record.
Please reply if you guys have any suggestions. Or, forward the same to your friends.
Thanks in Advance.
Shankar Shanmugam<br />Sun Certified Programmer for Java 2 Platform<br />Sun Certified Developer for Java 2 Platform<br />Email: firstname.lastname@example.org<br /> "Walking on water and building IT Architecture from <br /> specification are easy if and only if both are frozen"<br />-----------------------------------------------