Data type double fields in an Access 97 file appear as integers in ArcMap

Description

Data type double fields in an Access 97 file are displayed in the ArcMap as data type integer.

Cause

This is a known issue when the connection to the Access 97 file was made with the Microsoft OLE DB provider for ODBC drivers.

Solution or Workaround

1. Right-click the table in the ArcMap Table of Contents window to bring up the context menu and click Properties.
2. Select the field that is incorrectly formatted.
3. Click Format and change the number of decimal places to show in the table window.
4. Click OK to accept changes.
5. Click Apply to commit the changes.
6. Click OK to close the Properties dialog box.