File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes lock on MS Access 2000 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "lock on MS Access 2000" Watch "lock on MS Access 2000" New topic

lock on MS Access 2000

Rajeev Ravindran
Ranch Hand

Joined: Aug 27, 2002
Posts: 455
Im using MS Access 2000 for my application..Sometimes while im deleting or updating the table rows, it throws this exception..
Exception occured in DbConnection exeQry() [Microsoft][ODBC Microsoft Access
Driver] Could not update; currently locked by user 'admin' on machine 'RAJEEV'.
wat cld be the reason for this lock ?? how can i avoid this ?? cld any1 help me ?

SCJP, SCWCD, SCBCD, Oracle Certified Professional (SQL n PL/SQL)
Joel McNary

Joined: Aug 20, 2001
Posts: 1824

Did you have Access open at the time? (In particular, did you have the view of the table open is access at the time?)
Having the view open in Access prohibits any other application from modifying the data in that table--you will get this error if you do so.

Piscis Babelis est parvus, flavus, et hiridicus, et est probabiliter insolitissima raritas in toto mundo.
I agree. Here's the link:
subject: lock on MS Access 2000
It's not a secret anymore!