I have a database with 30K records, AC2K and Jet 4.0.

The user will have the ability to type the desired record and bring in the information (15 or so fields, no images, plain text and some dates).

So far I populate the dataset at form load, it takes some time and after that I use .find(key) to bring on the record. Question: Would it be advisable to populate the dataset only with the desired record using the SQL string each time, or ist it better performance wise the way I have been doing it?

Thanks.