very slow query on access databse over Lan dir

I use the tipical ado jet ole 4.0 connection and VB6 classic. for example:

Set CONN = New ADODB.Connection
With CONN
.Open _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\DATABASE\QA1.mdb;" & _
"Jet OLEDB:Engine Type=4;"
.Properties("Jet OLEDB:Max Locks Per File") = 25000000
End With

and i open the recordset with:

Set RSTX = New ADODB.Recordset
RSTX.CursorLocation = adUseClient
SQL = "SELECT ecc where ecc"
RSTX.Open SQL, CNT, adOpenStatic, adLockReadOnly, adCmdText

but the result of query is very very very slow.

I need assistente for conn and recordset.for correwt the setting

suggest my is i need to add cursor type or change completly the strategy.
Tks

 

only the query.
But i think a good connection improve the good query.