I am trying to access a .dbf using visual basic. I use the following code

connDBFFile.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Persist Security Info=False;Data Source=" & _
"C:\" & ";Extended Properties=""DBase IV;"";"

connDBFFile.CursorLocation = adUseClient

Set rs = New ADODB.Recordset
rs.Open "Test.dbf", connDBFFile, adOpenKeyset, adLockPessimistic, adCmdTable

the code works fine every where but there is huge difference in performance of the same.

If it is used on 98 machine it is very fast and 2000 machines it is very slow, but there are 1 in 20 ms windows 2000 machine where this runs very fast. Can someone suggest the reason