>I've got an application where the database resides on a shared network folder.
>
>When more than one user accesses the program the app slows down or continuously displays the 'running query' progress bar over and over again.
>
>All of the forms are running in private data sessions.
>
>I use 'select ... into cursor tmpxyz' statements to load combo boxes, etc. on some of the forms.
>
>With just one user accessing the program it runs okay although it runs much faster on the machine which has the database locally.
>
>Any suggestions?

Try temporarily disabling any real-time file scanning portion of antivirus software running on all the involved workstations, and the server computer.