Hi

I use ASP to display and edit data from my MS SQL DB, many users need to have access to the same data. But only one can have write access to the same records at the time, who do i solve this problem?
The other users should get the records in read only.

Brian Jensen

You need to use a LockType parameter when you write data to database, i.e., adLockPessimistic lock.

<%Response.Buffer = True%>

Buffer That Output by Charles Carroll
http://www.learnasp.com/advice/whybuffer.asp
Buffering is enabled by default starting in IIS 5, but one must still do it manually in IIS 4.