A recently revealed bug in Microsoft Access, the company's desktop database application, can corrupt data by overwriting one record with information from another. Microsoft confirmed the bug on Tuesday, which can occur in a form view with numerous records.
"It really would be something that would be more typical of a power user," said John Duncan, a product manager for Microsoft Office.
Microsoft says it will have a patch next week, but for now you can use the following work-around: Enter the Design View in Access, right-click on the combo box, and type "me.requery" into the dialog box. Then save it. The company says the bug is limited to Access 97 and does not affect Access 95 or Access 2.0