>Hey guys,
> We have a multiuser application. whenever the users attempt to modify the same record, they get the "Attempting to lock ... Press Escape to Cancel" message. How do i get rid of this message?? I read on the msdn site that I could make changes in the tools->options->data tab.. It's rather annoying for them as they can't select any other record.. Thanx for the help..
>
>Sameer

You should not try to use table in transaction while using it in other session. In other words, try to minimize time when the tables are used in transaction.