How to know if a table is lock by other users

[Ou Lanhui]

I developed a multi-user system, I want to know if the table locked with I
do a long time update query. So, I want to know how to do so. Is it need
MSysACEs table?

Thanks a lot.


Ou Lanhui

 

[Tom van Stiphout]

On Wed, 2 Apr 2008 14:34:32 +0800, "Ou Lanhui" <[email protected]>
wrote:

The typical method is to have an error handler in your procedure. It
will catch any errors (including multi-user) that may occur when you
run your Update query. There is no need to test ahead of time. Just
run it and be prepared to handle the possible error.

That error handler could well be a bit more sophisticated than:
Msgbox Err.Description
For example it could use the Sleep API to sleep for a second and try
again, and it could do this up to N times after which a message would
be given to the user.

-Tom.

 

[Ou Lanhui]

Is this a secret?