You may receive an error message when you try to convert a Microsoft Access 2000 or a later version database to a Microsoft Access 97 database (887032)


The information in this article applies to:

  • Microsoft Office Access 2003
  • Microsoft Access 2002
  • Microsoft Access 2000
  • Microsoft Access 97

SYMPTOMS

When you try to convert a Microsoft Access 2000 or a later version database to a Microsoft Access 97 database, you may receive the following error message:
Invalid field data type

CAUSE

This problem may occur if your database contains the Number data type. Then, the Number data type must have the Field Size property set to Decimal.

RESOLUTION

To resolve this problem, change the Field Size property for the Number data type from Decimal to Double.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For additional information about new database features, click the following article number to view the article in the Microsoft Knowledge Base:

275561 Description of the new features that are included in Microsoft Jet 4.0

Modification Type:MinorLast Reviewed:7/28/2006
Keywords:kbconversion kberrmsg kbtshoot kbprb KB887032 kbAudEndUser
©2004 Microsoft Corporation. All rights reserved.