J
joan
Hi,
I have designed an application that with Access linked
tables that link with SQL Server, i.e. the backend is SQL
Server. The performance is quite good, but sometimes the
following error display 'the record is locked by another
users'. At the beginning, I think the record is really
edited by another users. But, afterwards, I found that it
is not. It is because the record is locked everytime when
I try to edit the same record. May I ask how can I unlock
an record or release the lock in link Access MDB or SQL
Server. The system has been run for about 3 years. The
performance is not bad except the 'locked record' error.
Thanks in advance.
Cheers,
Joan
I have designed an application that with Access linked
tables that link with SQL Server, i.e. the backend is SQL
Server. The performance is quite good, but sometimes the
following error display 'the record is locked by another
users'. At the beginning, I think the record is really
edited by another users. But, afterwards, I found that it
is not. It is because the record is locked everytime when
I try to edit the same record. May I ask how can I unlock
an record or release the lock in link Access MDB or SQL
Server. The system has been run for about 3 years. The
performance is not bad except the 'locked record' error.
Thanks in advance.
Cheers,
Joan