thank you for giving me alternative solutions for this particulat problem. however, i still encounter the same problem once in a while. all the tables (SQl) i am using have already their respective indeces. do you think there are problems with the codes which i used in visual interdev? help me, pls.