ACC2002: Error Message: Microsoft Access Is Unable to Start the Lookup Wizard (318809)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q318809
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you try to use the Lookup Wizard for a data type of a field, you may receive the following error message:
Microsoft Access is unable to start the Lookup Wizard. The Lookup Wizard doesn't apply to fields of this data type.

CAUSE

The data type of a field was set to something other than Text, Number, or Yes/No before you started the Lookup Wizard.

RESOLUTION

To work around this behavior, make sure that the Default field type box on the Tables/Queries tab of the Options dialog box is set to Text, Number, or Yes/No before you start the Lookup Wizard. To do so, follow these steps:
  1. Open your database in Access.
  2. On the Tools menu, click Options.
  3. Click the Tables/Queries tab.
  4. In the Default field type list, select Text, Number, or Yes/No.
  5. Click OK to close the Options dialog box.

REFERENCES

For more information about about the Lookup Wizard, click Microsoft Access Help on the Help menu, type lookup wizard in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:9/26/2003
Keywords:kberrmsg kbprb KB318809
©2003 Microsoft Corporation. All rights reserved.