File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "lock on MS Access 2000" Watch "lock on MS Access 2000" New topic
Author

lock on MS Access 2000

Rajeev Ravindran
Ranch Hand

Joined: Aug 27, 2002
Posts: 455
hi,
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 ?
Thanks,
raj


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

Joined: Aug 20, 2001
Posts: 1817

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.
 
 
subject: lock on MS Access 2000
 
Similar Threads
Cpntainer Managed EJB - MS Access
Different versions of SQL Server
MS Access 2000 on web
setting lock timeout
Tomcat 4.0 running slow !!!