Microsoft Access Hit By Silent Data Loss Bug

A SERIOUS bug has surfaced in Access 97 that can potentially corrupt user databases without users being aware of it.

The bug affects Access 2, Access 95, and Access 97.

The bug can potentially cause edits to a record to be applied to a different record, which effectively corrupts the data in both of them. It appears that it only happens to Access database applications that rely on VBA programming, where an unbound Combo Box is employed in form view to navigate between records with the RecordsetClone and Bookmark commands, a fairly common programming technique. A detailed explanation of the bug can be found at http://odyssey.apana.org.au/~abrowne/BugBookmark.html.

The workaround: go to Access's Design View, right click on Combo Box and enter me.requery into the dialog box, and click Save.

Microsoft says a code fix will be included Service Release 2 for Microsoft Office.

-- Bruce Kratofil

© BugNet material copyright 1994-1999 by BugNet.
® BugNet is a Registered Trademark of KeyLabs.
Astonisher.com material is
© Copyright 1973 - 2020 by Bruce Brown and BF Communications Inc.
Astonisher.com is a trademark of BF Communications Inc.

This historic replica of BugNet from the period 1994-1999
is presented by astonisher.com with the permission of BugNet.

BF Communications Inc.
P.O. Box 393
Sumas, WA 98295 USA
(360) 927-3234

Website by Running Dog

* Here's Bruce Brown's BugNet Memoir...
* Here's the free BugNet from 1999...