I want to use a grid control to show a local (Jet table) database that
gets a new record every second or so. I would like the user to be able
to scroll through the entire table, but it's a large table, and it can't
fit in memory. When I just make the table the recordset object of a
data (e.g., ADODC) control, by the delay and disk access I assume it is
trying to read the whole table into memory. Is there any way to do what
Access does---to have a grid that you can scroll to view the whole
table, without having the whole table in memory?
Thanks for any advice,
Mark