>>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?
No, I don't use those... They are something like:
select field1, field1 from table where ... into cursor tmp
:)