Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

The data of the primary key column is not in the Data View of a list in Windows SharePoint Services 3.0 when you export a table in Access 2007


View products that this article applies to.

Symptoms

You export a table from Microsoft Office Access 2007 to a list in Microsoft Windows SharePoint Services 3.0. When you do this, the original data of the primary key column is not in the Data View of the list.

This issue occurs when the data type of the primary key column of the Access 2007 table is one of the following data types:
  • Number
  • AutoNumber

↑ Back to the top


Cause

This issue occurs because Access 2007 exports the data of the primary key column to a new hidden _ID column. By default, the _ID column is not added to the Data View of the SharePoint list.

↑ Back to the top


Resolution

To resolve this issue, add the hidden _ID column to the Data View of the SharePoint list. To do this, follow these steps:
  1. Connect to the Windows SharePoint Services 3.0 Web site that contains the exported table.
  2. In the View All Site Content pane, click Lists.
  3. Click the SharePoint list that contains the hidden _ID column.
  4. Click Settings, and then click List Settings.
  5. In the Views section, click All Items.
  6. In the Columns section, click to select the Display check box of the _ID column, and then click OK.

↑ Back to the top


More information

When Access 2007 exports the primary key column data of a table to a SharePoint list, a new primary key column is created. The new column is assigned the name "ID" and the AutoNumber data type. The original primary key column is assigned the name "_ID," and is not assigned the AutoNumber data type.

When the table is exported, each record is assigned a new unique key value in the ID column of the new SharePoint list. The original data of the primary key column is moved to the hidden _ID column. Therefore, the export process can be confusing, because the primary key column names are switched and because the original primary key column data is hidden.

For more information about how to export a table or a query to a SharePoint site, visit the following Microsoft Office Online Web site: For more information about how to add, to set, to change, or to remove the primary key, visit the following Microsoft Office Online Web site:For more information about how to modify the columns in a Data View, visit the following Microsoft Office Online Web site:

↑ Back to the top


Keywords: KB926524, kbprb, kbtshoot, kbexpertiseinter, kbdatabase, kbexport, kbtable

↑ Back to the top

Article Info
Article ID : 926524
Revision : 3
Created on : 11/16/2007
Published on : 11/16/2007
Exists online : False
Views : 374