I'm developing a database application, connected to an Access database. In my application I'm using data controls to retrieve data from database tables. Some of the tables store tens and hundreds of thouthands records, so refreshing of data controls takes few minutes to execute and, therefore, undesirable.
My problem that the database can be changed from an external application, so the data controls should be able to work with added/changed data. My recordsets are dynaset type, so I assume, that thay should be connected to the database, and able to get recent changes from it, but I cannot find, how can I achieve this. Maybe someone can halp me with this or suggest another approach of database connecting, so that the full refresh would be unnessesary?
I think, it's common problem in large database programming, so there should be some solutions of it? Am I wrong?

Thank you in advance,

Jack.