Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Visual Basic
Expertise: Beginner
Feb 18, 2000



Building the Right Environment to Support AI, Machine Learning and Deep Learning

ADO and Large Tables

I have several MS Access97 database tables that are larger than 120 MB. When I use ADO to open the entire table it seems to try to load the table into memory, this crashes the machine it is running on. Is there anyway to limit the amount of memory used by ADO?

If you don't need all the data back at the same time, you might want to try using the PageSize/PageCount properties of a static recordset. If you open your recordset as adOpenStatic, you can set the PageSize property to be the number of records you want back at a time.

The PageCount property will then be populated with the number of pages (full or partial) that are in the recordset. You can then use the AbsolutePage property to jump immediately to a particular page. This method is much more efficient when it comes to large recordsets and large databases.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date