Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC Microsoft Access Driver Could not update; currently locked by user

843854Jan 18 2005 — edited Jan 18 2005
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 15 2005
Added on Jan 18 2005
2 comments
599 views