We are using the recordset object to load a dbf which we then perform a search against to retrieve the needed values to populate a table form. The client has been complaining that the loading of these records is slow, so we are looking for a quicker way to load and search the dbf.
We tried loading the dbf once when the application is loaded, but subsequent searches are crashing the app. Odd.
Is there another suggested method to make the loading of the DBF faster? Someone within our organization suggested converting the DBF recordset to an array, then using that. Is this feasible? If yes, how is this accomplished?
