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!