thank you for your post. it helps me a lot to get the server upgraded.

This brings some insight. The comment of Bob makes sence. We are talking about milliseconds of delay probably for a specific user (if he/she is user 6, 7 or 20)?...

hmm, that's bad news Bill. 🙁

Thank you Linda, I have to reboot the server. There's nothing strange in the (error) logs.. Restarting SQL does not help. Any idea what the optimal amount of memory is...

Fantastic! This is the info I needed. Thanks Brian! 🙂

Thank you guys! 🙂

This forum is great!

Thanks it worked! On the page that displays the results I select the right records from the view through a browser querystring

Thanks Charles for your help, it helped. I found the solution, it is quite simple 😎

If (Recordset.Fields.Item("thefield")) = "" or ISNULL(Recordset.Fields.Item("thefield")) THEN

- without the .value

- both = "" and...