Record locks in MS Access
Posted on 2011-10-18
I think I already know the answer to this, but thought I would look sof some advice from the experts.
We run a bit of production control software in the factory/offices. This was written by a guy years ago, we have since parted company and are currently in process replacing these systems. (quite a vulnerable position).
We are having an issue with one particular area of the system. When USER A attaches raw material to a job he crashes 50% of the time with Runtime Error 13, type mismatch.
On further investigation we have found that if USER B is in a stock search screen, USER A crashes out (seems strange that the error is type mismatch, but true). This is a nightmare as the whole factory uses this machine.
Is there any way from MS Access (or 3rd party tool) to view current record locks, or does anyone else have any gems of wisdom? Could I even get a clue through the ldb file?
DB = Access 2000
App = VB6