MSAccess - Detecting Record Locks
Posted on 2009-02-23
I want to be able to detect a record that is open by another user before they actually open the record. This is a shared database. Currently using Access 2000.
I could have the app create a log file so when a user opens a record, it is written to a table. When another user tries to open that same record, I can check the table and see if it's open. But that's problematic in case the other app locks up and crashes, and I don;t have the chance to clear the log table. I've seen other solutions but they require that you get into the record first before finding if another user is in it. I want to pre-empt that and detect it 'before' the user tries to access the record. There must be someway to check the record in the Jet engine to see if someone else has it open. Access knows when you open the record especailly with pessismistic locking. So where is the flag that tells me the record is locked?