共享链接表上的索引 [英] Index on Sharepoint Linked table

问题描述

我正在使用MS Access 2010，并且已经在数据库中创建了共享点链接表.

I am using MS Access 2010 and I already have sharepoint linked table created in the database.

我想知道如何在此链接表上创建索引.当我要设计链接表的视图并单击索引时，无法在链接表中修改类似此属性的消息.

I wanted to know how i can create indexes on this linked table. When i am going to design view of linked table and clicking on indexes cloumn getting message like this property can not be modified in linked table.

我实际上是试图在链接表的顶部运行一个查询，并且在执行性能分析然后获得在链接表的几个字段上创建索引的消息时花很长时间来返回结果.

I am actually trying to run one query on top of linked table and its taking very time to return resutls when doing Analyze performance then getting message of creating indexes on few fields of linked table.

推荐答案

您当然可以从具有链接表的Access创建索引并将其设置为SharePoint.

You can most certainly create and set the indexes from Access with a linked table to SharePoint.

执行此操作的方法是在表视图(而非设计视图)中显示链接表.然后在功能区中单击索引按钮.这是一个屏幕截图:

The way you do this is bring up the linked table in table view (not design view). Then in the ribbon you click on the index button. Here is a screen shot:

当然，如果您想在SharePoint网站上调出表格并以这种方式添加索引，也可以.

You can also of course if you want bring up the table on the SharePoint site and also add the index that way.

请注意，您还可以使用此布局模式从Access向SharePoint表添加新列.

Note that you can also use this layout mode to add new columns to the SharePoint tables from Access.

这篇关于共享链接表上的索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！