Problem - cont’d
Problem - cont’d
Storing Search Results
- Needed to be able to store any given set of fields in any order
- Current storage of search records to local table could not accommodate
- If we stored return fields as text, could not access them as a recordset
- Individually inserting records into the database was processor intensive and very slow.
- All of the writing and reading from the ACCESS database were causing it to be corrupt.