ODBC Microsoft Access Driver Could not update; currently locked by user
843854Jan 18 2005 — edited Jan 18 2005Hi All,
I am getting the below exception, when I try to update a record in MS-Access database. Its a desktop appplication that does the update here.
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 Windoews 2K with service pack 4.
I suspect either the driver or because that we use two different Connection/Process to update the same record.
Please reply if you guys have any suggesstion.
Thanks in Advance,
Shankar