Hi,

I am writing a web application with ASP and SQL Server 2000. The app basically enables the manipulation of data in the database. When I open a recordset, I do so with pessimistic locking.

Scenario:

Two people, A and B, are using my app at the same time. A opens a record, and therefore B is barred from opening it.

However, while A has the record open, B goes (in his browser) to the page that requests the opening of the record.

Question:

What happens to B's request? Is it discarded (and lost) by the server, or does the server queue it and execute it when A releases the record? If queueing takes place, how many requests can wait in a queue?

I am new to the way in which multi-user apps ought to be programmed, and this is an area I don't understand. Please can you help me see how this works, and if I need to apply special techniques for catering for multiple users?

Thanks.

James

//##

Cross post to this thread.

Peter
------------------------------------------------------
Work smarter, not harder.