Microsoft KB Archive Search

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.

  1. Home
  2. "Errors have prevented one or more tables from being uploaded to the server" error message when you try to publish an Access 2010 database to a SharePoint site

"Errors have prevented one or more tables from being uploaded to the server" error message when you try to publish an Access 2010 database to a SharePoint site

Symptoms

When you try to publish a Microsoft Access 2010 database to a SharePoint site, the publishing process fails and one of the following errors appears in the Move to SharePoint Site Issues table:

  • There was an error uploading the data in the tables being created on the server. Failed to rename the field 'Field_Name' on the SharePoint list 'List_Name'.

  • Errors have prevented one or more tables from being uploaded to the server.
  • Error modifying list schema. Failed to rename the field 'Field_Name' on the SharePoint list 'List_Name.
  • Errors have prevented one or more tables from being uploaded to the server.

↑ Back to the top

Cause

This issue occurs because the SharePoint server has a limitation on the number of columns and fields that can be in an Access 2010 Web database.

↑ Back to the top

More Information

The following are limitations imposed on an Access 2010 Web database:

  • Each row in a Web database cannot be larger than 8 kilobytes (kb).
  • No more than 20 indexed columns are permitted.
  • The following is the maximum number for each different field type:
    • 48 Date and Time fields
    • 71 Number fields
    • 191 Memo fields
    • 180 Text fields

↑ Back to the top

Keywords: kbdatabase, kbexpertiseadvanced, kbtshoot, kbsurveynew, kbprb, kb

↑ Back to the top

Article Info
Article ID : 982795
Revision : 1
Created on : 1/7/2017
Published on : 1/27/2018
Exists online : False
Views : 184