There are many things a developer can do to squeeze an incredible amount of power and performance out of an Access database. The first, and foremost, is to use subforms to avoid loading data until you need it.

This story continues at http://www.databasejournal.com/featu...le.php/3599781