Use Only the Functionality You Need

Microsoft® Jet will generally default to giving you the most powerful functionality available. For example, if you open a Recordset on an ODBC database, Jet will try to return a dynaset, which is a fully updatable, scrollable set of records. This can be particularly expensive if the query was a multitable join because Jet has to simulate the updatability because most servers do not support updatable joins. Some simple changes include:

• Don't use scrolling cursors if you don't need to scroll. Many applications only move forward through result sets.

• Don't use updatable cursors if you're only reading.

More specific information on how to do this in DAO is provided below.