|
| Hello and thanks for reading my question. I'm not sure if this is the
correct forum for this post so if not please let me know. :)
We have an application in our law office, which tracks/manages cases. It
has a SQL database with a MS Access, vb6 front end. Occasionally, when
trying to edit a record, it seems that the particular record has been locked
for editing.
The user will make the change to some field in the record, when they go to
save, the application kind of freezes up, gives the hour glass for a few
minutes, then gives the message:
"ODBC - update on linked table 'case table' failed. [Microsoft] [ODBC SQL
Server Driver] Timeout expired (#0)
It will only seem to be that particular record that can't be updated, other
records do not have the same problem. We can't update the record usually for
several days, but finally it seems that whatever was locking it stops.
I have been unable to find any way to fix the problem when it happens. As
you can imagine it can be inconvenient to be unable to update a record
related to law cases for a few days. It happens maybe once a month.
So has anyone seen anything simililar or know of anything I can check or do
to see what's causing the problem.
|
|