Slow ADO Query over Access with VB6 over a LAN

[Visual Basic]

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...