My program uses MS Access as DB and Visual Basic 6. I've experienced an issue loading a recordset with about 300000 records, some fields indexed, when I place a SELECT SELECT * from Materials m INNER JOIN Quantity s ON m.code=s.materialcode ORDER BY code
in a ADO recordset with the following configurations:
Provider: Jet;OLEDB CursorType: adOpenForwardOnly LockType: adLockReadOnly CursorLocation: adUseClient
I place the query and pass to a datagrid, I've not to edit or modify the records ***
Strangely, if I use on the same machine where I've the .mdb file is fast, from other clients is slow (approx. 15 seconds).
What Can I change? Thanks