| 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: 1815
|
|
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
|
|
|
0
