hi, i was wondering if anyone could help me on how to release a record lock while it is being modify (in edit mode)?

i have an Excel macro that will connect to MS Access database by using DAO, at the beginning of my codes i have also implemented row-locking by using ADO (because DAO by default is page locking)

each time when user retrieve a record from the database, the macro will lock that particular row so that other users can't modify it. i have used "recordset.edit" to lock a record, it works fine

however, right now my concern is that what if a user retrieved a record and locked it for a long time (or somehow the user's pc got hang or something), there is no way for me and other users to modify or to release the lock

i have tried using "dbengine.idle dbfreelocks" but it doesn't seems to work, is there any way using VBA (in Excel or Access) to unlock a record while a user is modifying (in edit mode)??

or maybe is there a way that i can open up the MS Access database and do something to release the lock?

thank you.