Microsoft KB Archive/828413

= The default field names in a Windows SharePoint Services list are preceded by underscore characters =

Article ID: 828413

Article Last Modified on 6/3/2004

-

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
 Start Access 2003. Open the sample database named Northwind.mdb.  Create a new table named Test with the following fields: Table: Test

Edit       Text ID     Text Attachments Text Title      Text  In the Database window, under Objects, click Tables. In the right pane, right-click the Test table, and then click Export.</li> In the Export Table Test To dialog box, click Windows SharePoint Services  in the Save as type list.</li> In the Export to Windows SharePoint Services Wizard, in the Site box, specify the Windows SharePoint Services site, and then click Finish.</li> Click OK.

Note When you click OK, an exported list named Test opens in Datasheet view in the Windows SharePoint Services site.</li> In the Test list, click Show in Standard View.</li></ol>

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.

Additional query words: ACC2003 WSS

Keywords: kbexport kbprb kbfield KB828413

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.