Hi, I would really appreciate it if someone can help me with my problem. In my ASP script i'm using a simple select statement<BR>"select * from table1" <BR>to retirve records from a SQL Server7.0 database. This table has about 2000 rows, one of the fields is an nText field. Now the problem is when i open up the page, that query is retrieving different number of records everytime. For example one time it retrieves 5 records, if you refresh immediately, i might retrive 50 records, 100 records or none. Only thing i can think of is bad database/network connections problem. I even tried using different types of lock types, like adLockOptimistic or adLockReadOnly etc. Even these did not help.<BR><BR>I would really appreciate if someone can direct me in the right direction.