PROBLEM

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

Last Published: April 25, 2020

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.

Article ID:000002636

Software:
  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic