ACC97: Expression Builder Does Not Work as Expected (298981)



The information in this article applies to:

  • Microsoft Access 97, when used with:
    • Microsoft Office 2000 Small Business

This article was previously published under Q298981

SYMPTOMS

When you try to use the Expression Builder in Microsoft Access, the Expression Builder may not work as expected.

CAUSE

This behavior can occur if you install Microsoft Access 97 on a computer on which Microsoft Office 2000 Small Business Edition is also installed.

WORKAROUND

To work around this issue, follow these steps:
  1. Click Start, point to Search, and then click For Files or Folders.
  2. In the Search Results dialog box, type msaexp30.dll under Search for files or folders named, and then click Search Now.
  3. In the Search Results pane, click the msaexp30.dll file (typically found in the Program Files\Microsoft Office\Office folder), and then click Delete on the File menu.
  4. Reinstall Access 97.

Modification Type:MinorLast Reviewed:1/7/2006
Keywords:kbprb KB298981