>Hi All,
>
>I have had reports and a colleague has confirmed that a query takes significantly longer if the table being queried is open shared so:
>
>Select a.* from Customer a Into Cursor curCustomer where ??? && takes 2 seconds when I am the only user in the system
>
>The same query takes 5 seconds if the table customer is open by another user.
>
>No views involved
>
>Any ideas please?

Mathias,
did you have appropriate indexes that match the WHERE clause so the query can be optimized?
I can't remeber if the VFP6 has this function but you can try:

IF _VFP.StartMode == 0 && Just in case you forgot to delete following line
   SYS(3054,12,"sqlText")  
ENDIF
Select a.* from Customer a Into Cursor curCustomer where ??? 

IF _VFP.StartMode == 0 && Just in case you forgot to delete following lines
   SYS(3054,0)
   MessageBox(sqlText)
ENDIF

and see what Messagebox shows.