Bonnie,

Thanks! We give users fields were they can specify what they want to look for (i.e. date range, item #, customer #, etc...). If they leave all the fields blank and hit search, (this is in our VFP app) they get everything from the table. With just a handful of clients, there are tables with over 250,000 records.

Just so I understand, you're advising me to limit that query command to a max number of records?

What happens with someone with low RAM, machine dies?

Is there any provision for this in .NET?

Sorry for what seems to be stupid questions, but I'm trying to put .NET into the real world.