MS Access discussion...
Posted on 2001-07-03
Basics: VB6 sp5, Windows NT 4.0
Question: I have a VB app that uses Microsoft Access to store data. When I have a table with just 10 fields, the read/write to the table is fairly quick. But when I increase the number of fields to 20, the speed drops down significantly. When the number goes to 30 or more, Access really slows. Ideally I would like to have a table with about 65 - 70 fields in it and that would be so slow when I add 30,000 records.
The number of records in the table does not seem to matter much nor does the definition of the fields. The only thing that seems to really matter is the number of fields in the table. This reminds me of Paradox, at least versions 5 and 6 from the DOS world. Borland's suggestion was to get a faster computer.
Any suggestions? I can't break up the table into smaller tables with fewer fields.