| Author |
MS Acces Error Could not update; currently locked by user
|
Shankar Shanmugam
Greenhorn
Joined: Sep 12, 2001
Posts: 23
|
|
Hi All,
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: shankar.s@vsnl.net<br /> "Walking on water and building IT Architecture from <br /> specification are easy if and only if both are frozen"<br />-----------------------------------------------
|
 |
Paul Sturrock
Bartender
Joined: Apr 14, 2004
Posts: 10336
|
|
|
Unfortunately your problem is MS Access. It is notoriously bad at handling concurrent access. Its not really an RDBMS, rather a single user data repository.
|
JavaRanch FAQ HowToAskQuestionsOnJavaRanch
|
|
 |
|
|
subject: MS Acces Error Could not update; currently locked by user
|
|
|
0
