hi,
recently i received an error message from my user as following:

Microsoft Cursor Engine (-2147217864): Row cannot be located for updating. Some values may have been changed since it was last read.

after a few investigation, i found this error was caused by 2 of the users updating the same record at the same time at different pc.
Is it anyway to check whether the record is updating by multi user?

Thanks.

Hi,

I am not sure which database you are using. But what I can tell you is if you're using ADO, you can include the "Mode=Share Deny Read|Share Deny Write" in the Provider in order to restrict the user access to 1 user at a time.

Regards,

Srinivas.

Hi Srinivas,
Thanks for your advice.
Currently I'm using ADO connection access to MSSQL database. By using the way u propose to me, it still return me an error as stated above. What I need is to get which record have been updated by user B so I can notify user A that the record is being changed by user B.

Regards,

Yee Fan.

Hi Yee Fan,

I am not very familiar with MSSQL. To my knowledge, I do not think you would be able to do that. What you have stated is a typical example of a row lock and the message that the server/system gives is sometimes very generic (it doesn't give who is doing/has done what).

You would not be able to achieve what you've said below manually from your application. If that is the case, you have to trace each and every user's actions using your application, keep track of who updated each record first etc. and this itself would become like a database engine on its own!!! Moreover, all these are already being done by the MSSQL database which why you're getting this generic message!! You may take your DBA's help in this regard to see if something can be done.

Alternatively, you may restrict the user access to 1 user at a time or provide module level access within your application. The Share deny read|Share deny write should work. You may give me that part of the coding and I'll try to find out what's the problem.

Regards,

Srinivas.