Slow Performance in Jet 3.51 When Editing Recordset Generated from SELECT Statement

• Microsoft Data Access Components version 2.0
• Microsoft Office 97 for Windows

SYMPTOMS

Performance is slow when using a Microsoft Jet Database Engine 3.51-based application and editing a recordset generated from a SELECT statement. The problem is seen when editing the first record in the recordset, although all subsequent edits of the same recordset occur within expected timeframes. The performance hit increases with the number of columns in the query.

This performance problem does not occur if the records are edited by directly opening the table (for example, when using adCmdTableDirect in ADO). There is also no performance hit if the tables were created using CREATE TABLE statements rather than CreateTableDef() statements in DAO.

This problem occurs with Jet 3.5 versions after 3.51.2723. This performance issue does not occur with Jet versions 3.50.3428.0 (Office 97 original release) and earlier, and also does not occur with any Jet 4.0 version.

RESOLUTION

A supported fix that corrects this problem is now available from Microsoft, but it has not been fully regression tested and should be applied only to systems experiencing this specific problem. If you are not severely affected by this specific problem, Microsoft recommends that you wait for the next Jet 3.51 Service Pack that contains this fix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the fix. For a complete list of Microsoft Product Support Services phone numbers and information on support costs, please go to the following address on the World Wide Web:

http://www.microsoft.com/support/supportnet/overview/overview.asp

WORKAROUND

Create new, matching tables using CREATE TABLE statements; move your data into the new tables, and swap the names of the old and new tables.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: slow performance jet 3.51 query edit

Keywords : kbAccess97 kbJET kbGrpMDAC
Version : WINDOWS:2.0,97
Platform : WINDOWS
Issue type : kbbug