The default field names in a Windows SharePoint Services list are preceded by underscore characters (828413)


The information in this article applies to:

  • Microsoft Office Access 2003
  • Microsoft Windows SharePoint Services
This article applies only to a Microsoft Access database (.mdb).

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

The names of the default fields in a Microsoft Windows SharePoint Services list may be preceded by an underscore character if both of the following conditions are true:
  • You export a table from Microsoft Office Access 2003 to a list in Microsoft Windows SharePoint Services.
  • The table contains fields that have field names that are the same as the default field names in the Windows SharePoint Services list.
For example, if the table contains a field that is named Edit, the default field name is changed to _Edit when you export the table to the list in Windows SharePoint Services.

You may have the same problem if you export a list in Windows SharePoint Services to an Access database, and then export the Access table to a list in Windows SharePoint Services. This problem may also occur when you export the data from Microsoft Office Excel 2003 to a list in Windows SharePoint Services. However, the Windows SharePoint Services list adds a 1 to the beginning of the duplicate default field names.

CAUSE

Windows SharePoint Services creates default columns, such as ID, Edit, Attachments, and Title, in every list. When an Access table that includes columns that have the same names is exported to a list in Windows SharePoint Services, Windows SharePoint Services imports the fields and creates the default columns. Because Windows SharePoint Services does not permit duplicate fields in lists, the default columns start with an underscore character in the field name, such as _ID or _Edit.

STATUS

This behavior is by design.

MORE INFORMATION

Microsoft Office 2003 supports Windows SharePoint Services. As a result, you can export an Access table to a Windows SharePoint Services list. You can also export a Windows SharePoint Services list to an Access table.

Steps to Reproduce the Problem

  1. Start Access 2003.
  2. Open the sample database named Northwind.mdb.
  3. Create a new table named Test with the following fields: 
    Table: Test
------------------------
Edit		Text
ID		Text
Attachments	Text
Title		Text
------------------------
  4. In the Database window, under Objects, click Tables.
  5. In the right pane, right-click the Test table, and then click Export.
  6. In the Export Table Test To dialog box, click Windows SharePoint Services () in the Save as type list.
  7. In the Export to Windows SharePoint Services Wizard, in the Site box, specify the Windows SharePoint Services site, and then click Finish.
  8. Click OK.

    Note When you click OK, an exported list named Test opens in Datasheet view in the Windows SharePoint Services site.
  9. In the Test list, click Show in Standard View.
The Test list contains two fields named List and _List. The List field corresponds to the field in the Access table that is the source of the Test list, and the _List field is the standard default field that is created by Windows SharePoint Services when the Access table is exported to the Windows SharePoint Services list.
Modification Type:MinorLast Reviewed:6/3/2004
Keywords:kbfield kbExport kbprb KB828413 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.