>I'd like to thank all of you who replied to my question.

Peter,

I think this may also indicate a problem with your database or ap somewhere. If you can't do a select cause some transaction has locked the records needed, perhaps you should look at your transactions.

Are you beginning a transaction and not closing it as quickly as possible?

Are any or your trasactions started and then in a wait state for the user to do something before it is closed?

Also, what is your default transaction isolation setting? Maybe it is set to strict for you application. See the SET TRANSACTION ISOLATION LEVEL topic in SQL books on line.

BOb