Here is the break down:
I am using ADO w/ stored queries to access a Microsoft Database which contains over 2 million records. I have created indexes in the database on the fields in which I use to search.(Check Number, Amount, Date)
I have incorporated a MSFlexGrid control which displays any duplicate records. When I do a search on let’s say check number it returns all information and populates the grid just fine. When I try to search for an amount(field) and the program must retrieve a lot of data and populate the grid it gives me an out of memory error?
What in the heck can I do about that?
