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 'UserInfo' link is used by Microsoft Office Access to maintain your web application. It may not be deleted or renamed." error message when you try to delete a Web database table named Userinfo in Access 2010


View products that this article applies to.

Symptoms

Consider the following scenario:
  • You create a Web database in Microsoft Access 2010.
  • You publish the Web database to a Microsoft SharePoint site.
  • You open the Web database in Access 2010 on a client computer.
  • You create a table. You name the table Userinfo.
  • You synchronize the Web database that is located on the client computer together with the published version of the Web database that is located on the SharePoint site.
  • On the client computer, you try to delete the table Userinfo in the client-side copy of the Web database.
In this scenario, you receive the following error message:

The 'UserInfo' link is used by Microsoft Office Access to maintain your web application. It may not be deleted or renamed.

↑ Back to the top


Cause

This issue occurs because the word "Userinfo" is a reserved word in Access 2010 for web databases that are published to the Access Services area of a SharePoint site. For more information about reserve words in Access, click the following article number to view the article in the Microsoft Knowledge Base:

286335 List of reserved words in Access 2002 and in later versions of Access

↑ Back to the top


Workaround

To work around this issue, save the web database to a client computer as a local database, delete the table Userinfo from the database, and then republish the database to the SharePoint server.

↑ Back to the top


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

↑ Back to the top

Article Info
Article ID : 983274
Revision : 1
Created on : 1/7/2017
Published on : 9/17/2011
Exists online : False
Views : 99