>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?
>
>Thanks!
First quick verification - do you have NOFILTER or READWRITE clause in all your select statements?
If it's not broken, fix it until it is.
My Blog