I think the best suggestion I have seen is to have some type of AVI progress bar. Granted, the progress bar wouldn't be able to display total and percent done, but it could at least indicate progress, and the user wouldn't think something locked up.

BOb


>Some of the forms could have big queries
>To provide progressbar I did self made class , which has methods of setting
>time progress
>For file server queries I put this method directly in select clause, like one of the fields to select
>So, when long query runs, progress bar moves timemeter
>Is it possible to do similar thing for remote query for example on SQL server or Oracle
>Thanks in advance, Vladimir