Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MS Acces Error Could not update; currently locked by user

 
Shankar Shanmugam
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic