concurrency access/mssql

[Danny Nielsen]

Hi
Im developing an order database. So far, I've not been concerned about
concurrency issues because I thought that it was done by mssql. But at one
point I tested it with some users and it seemed that when I tried to insert
two orders with same orderno (primary key) at the same time, the 2. user got
an message that there had happened a violation on the primary key. Thats
good except that this popup screen continued to pop up whereby the user got
locked in this specific screen! Any idears why?

Thanks and best regards

Danny Nielsen
Denmark

 

[Chris]

Try pressing the escape key when the user gets stuck in
this screen.

HTH
Chris