在 SharePoint Server 2013 中為 Web 資料庫安裝及設定 Access Services 2010Set up and configure Access Services 2010 for web databases in SharePoint Server 2013

摘要:了解如何使用 Access Services 2010 修改並發佈原先在 SharePoint Server 2010 中建立的 SharePoint Server 2013 中的 Access web 資料庫。Summary: Learn how to use Access Services 2010 to modify and publish an Access web database in SharePoint Server 2013 that was previously created in SharePoint Server 2010.

Access Services 2010 是允許使用者修改並發佈原先在 SharePoint Server 2010 中建立的 Access web 資料庫 SharePoint 2013 中的服務應用程式。Access Services 2010 is a service application that allows users to modify and publish in SharePoint 2013 an Access web database that was previously created in SharePoint Server 2010.

在 Access 用戶端不需要以使用發佈的 web 資料庫。不過,在 Access 用戶端才可進行任何變更資料庫結構。The Access client is not required to use the published web database. However, the Access client is required to make any changes to the database structure.

設定 SQL Server Reporting ServicesSet up SQL Server Reporting Services

您可以更新現有的報表中的 Access web 資料庫,但這些報告需要在安裝及 SharePoint 和內容資料庫的 SQL Server Reporting Services 模式設定必須在執行 SQL Server 2012。如需詳細資訊,請參閱 SQL Server 線上叢書中的安裝 Reporting Services SharePoint 模式 for SharePoint 2013You can update existing reports in an Access web database, but these reports require the installation and configuration of SQL Server Reporting Services Mode for SharePoint and the content database must be running SQL Server 2012. For more information, see Install Reporting Services SharePoint Mode for SharePoint 2013 in SQL Server Books Online.

啟動 Access Database Service 2010Start Access Database Service 2010

若因任何原因尚未啟動 Access Database Service 2010,請執行下列操作:If for some reason Access Database Service 2010 has not been started, do the following:

  1. 在 SharePoint 管理中心網站上的 [系統設定] 下按一下 [管理伺服器上的服務]。On the SharePoint Central Administration website, under System Settings, click Manage services on the server.

  2. Access Database Service 2010服務、 [動作] 下的同一列上按一下 [啟動]。On the same row as the Access Database Service 2010 service, under Action, click Start.

建立 Access Services 2010 服務應用程式Create an Access Services 2010 service application

若因任何原因尚未建立 Access Services 2010 服務應用程式,請執行下列操作:If for some reason an Access Services 2010 service application has not been created, do the following:

  1. 在管理中心的應用程式管理] 下按一下 [管理服務應用程式]。In Central Administration, under Application Management, click Manage service applications.

  2. 在 [管理服務應用程式] 頁面上,按一下 [新增] 及 [ Access Services 2010On the Manage Service Applications page, click New, and then click Access Services 2010.

  3. 在 [ Access Services 應用程式名稱] 區段中輸入 Access Services 2010 在文字方塊中。In the Access Services Application Name section, type Access Services 2010 in the text box.

  4. 執行下列其中一項操作:Do one of the following:

    • 選取 [使用現有的應用程式集區] 選項,然後從清單中選取 [應用程式集區名稱Select the Use existing application pool option, and then select an Application pool name from the list.

    • 選取 [建立新的應用程式集區] 選項,然後在 [應用程式集區名稱] 文字方塊中輸入 AccessServicesAppPool。Select the Create new application pool option, and then type AccessServicesAppPool in the Application pool name text box.

  5. 選取 [可設定] 選項,然後選取 [從下拉式清單中的 [伺服器陣列管理員帳戶。Select the Configurable option, and then from the drop-down list, select the Farm administrator account.

  6. 按一下 [ OK ]。Click OK.

設定 Access Services 2010 設定值Configure Access Services 2010 settings

沒有 Access Services 2010 在初始安裝之後所需的任何其他設定。服務就可以做為 SharePoint 2013 安裝已完成。不過,您可以變更預設的組態設定以符合您的業務需求。下表包含可設定 Access Services 設定。There are no additional settings required after the initial installation of Access Services 2010. The services are ready to use as soon as the SharePoint 2013 installation is complete. However, you can change the default configuration settings to suit your business need. The following table contains the configurable Access Services settings.

  1. 確認執行此程序的使用者帳戶為 Access Services 2010 服務應用程式的網站管理員,並且具有設計師權限。Verify that the user account that is performing this procedure is a site administrator for the Access Services 2010 service application and also has Designer permissions.

  2. 在管理中心中,按一下 [應用程式管理] 區段的 [管理服務應用程式]。In Central Administration, in the Application Management section, click Manage service applications.

  3. 按一下要變更的 Access Services 2010 服務應用程式。Click the Access Services 2010 service application that you want to change.

  4. 在 Access Services 2010 設定頁面上,變更下表中顯示的任何設定。On the Access Services 2010 settings page, change any of the settings shown in the following table.

設定Setting 描述Description
清單與查詢Lists and Queries
針對 Microsoft SharePoint Foundation 清單使用的查詢設定Settings for queries used against Microsoft SharePoint Foundation lists
每個查詢的欄上限Maximum Columns per query
查詢中可以參照的欄數上限。請注意,查詢引擎可能會自動參照一些欄,而這些欄會被算入此限制中。The maximum number of columns that can be referenced in a query. Note that some columns may automatically be reference by the query engine and will be included in this limit.
有效值:從 1 到 255Valid values: from 1 to 255
預設值:40Default value: 40
每個查詢的列上限Maximum Rows per query
查詢中所使用清單可以包含的列數上限,或查詢的輸出可以包含的列數上限。The maximum number of rows that a list used in a query can have, or that the output of the query can have.
有效值:從 1 到 200000Valid values: from 1 to 200000
預設值:25000Default value: 25000
每個查詢的來源上限Maximum Sources per query
一個查詢可以輸入的清單數目上限。The maximum number of lists that may be used as input to one query.
有效值:從 1 到 20Valid values: from 1 to 20
預設值:12Default value: 12
每個查詢的計算結果欄上限Maximum Calculated Columns per query
內嵌的最大數目計算可以包含在查詢的欄、 本身的查詢或在其上任何子查詢為基礎。在基礎 SharePoint Foundation 清單中的計算結果的欄不包含在內。The maximum number of inline calculated columns that can be included in a query, either in the query itself or in any sub-query on which it is based. Calculated columns in the underlying SharePoint Foundation list are not included.
有效值:從 0 到 32Valid values: from 0 to 32
預設值:10Default value: 10
每個查詢的 Order By 子句上限Maximum Order by Clauses per query
查詢中的 Order By 子句數上限。The maximum number of Order By clauses in the query.
有效值:從 0 到 8Valid values: from 0 to 8
預設值:4Default value: 4
允許外部聯結Allow Outer Joins
允許在查詢中進行左右外部聯結。一律允許內部聯結。Allow left and right outer joins in a query. Inner Joins are always allowed.
核取方塊: 選取或清除 [允許外部聯結Check box: selected or cleared for Outer Joins allowed.
允許不可在遠端處理的查詢Allow Non Remote-able Queries
允許不可在遠端資料庫層處理的查詢執行。Allow queries that cannot be remoted to the database tier to run.
核取方塊: 選取或清除 [允許可在遠端處理的查詢Check box: selected or cleared for Remotable Queries allowed.
每個資料表的記錄上限Maximum Records Per Table
應用程式中的資料表可以包含的記錄數目上限。The maximum number of records that a table in an application can contain.
有效值:-1 (表示沒有限制)、任何正整數Valid values: -1 (indicates no limit), any positive integer
預設值:500000Default value: 500000
應用程式物件Application Objects
Access Services 應用程式可以包含的物件類型限制Limitations on the types of objects an Access Services application can contain
應用程式記錄大小上限Maximum Application Log Size
Access Services 應用程式記錄檔清單的最大記錄筆數。The maximum number of records for an Access Services Application Log list.
有效值:-1 (表示沒有限制)、從 1 到任何正整數Valid values: -1 (indicates no limit), from 1 to any positive integer
預設值:3000Default value: 3000
工作階段管理Session Management
Access 資料庫服務工作階段的行為Behavior of Access Database Service sessions
最大要求持續期間Maximum Request Duration
允許應用程式送出要求的最長期間 (以秒為單位)。The maximum duration (in seconds) allowed for a request from an application.
有效值:-1 (表示沒有限制)、1 到 2007360 (24 天)Valid values: -1 (indicates no limit), 1 through 2007360 (24 days)
預設值:30Default value: 30
每個使用者的最大工作階段數量Maximum Sessions Per User
每位匿名使用者允許的工作階段數目上限。如果使用者擁有此許多工作階段並啟動新的工作階段之使用者的 [最早刪除工作階段。The maximum number of sessions allowed per anonymous user. If a user has this many sessions and starts a new session, the user's oldest session is deleted.
有效值:-1 (無限制)、從 1 到任何正整數Valid values: -1 (no limit), from 1 to any positive integer
預設值:10Default value: 10
每位匿名使用者的工作階段上限Maximum Sessions Per Anonymous User
每位使用者允許的工作階段數目上限。如果使用者擁有此許多工作階段並啟動新的工作階段之使用者的 [最早刪除工作階段。The maximum number of sessions allowed per user. If a user has this many sessions and starts a new session, the user's oldest session is deleted.
有效值:-1 (無限制)、從 1 到任何正整數Valid values: -1 (no limit), from 1 to any positive integer
預設值:25Default value: 25
快取逾時Cache Timeout
資料快取仍然可以使用的最長時間 (以秒為單位),從每次要求該快取中的資料結束時開始計算。The maximum time (in seconds) that a data cache can remain available, as measured from the end of each request for data in that cache.
有效值:-1 (表示沒有限制)、1 到 2007360 (24 天)Valid values: -1 (indicates no limit), 1 through 2007360 (24 days)
預設值:1500Default value: 1500
工作階段記憶體上限Maximum Session Memory
單一工作階段可以使用的記憶體數量上限 (以 MB 為單位)。The maximum amount of memory (in MB) that a single session can use.
有效值:0 (停用)到 4095。Valid values: 0 (disable) through 4095.
預設值:64Default value: 64
記憶體使用量Memory Utilization
Access 資料庫服務上的記憶體配置Allocation of memory on Access Database Service
私用位元組上限Maximum Private Bytes
Access 資料庫服務處理序配置的私用位元組數上限 (以 MB 為單位)。The maximum number of private bytes (in MB) allocated by the Access Database Service process.
有效值:-1 (限制設為電腦上實體記憶體的 50%)、任何正整數Valid values: -1 (the limit is set to 50% of physical memory on the computer), any positive integer
預設值:-1Default value: -1
範本Templates
範本管理與相關的設定Settings related to template management
範本大小上限Maximum Template Size
Access 範本 (ACCDT) 允許的大小上限 (以 MB 為單位)。The maximum size (in MB) allowed for Access Templates (ACCDT).
有效值:-1 (無限制)、從 1 到任何正整數Valid values: -1 (no limit), from 1 to any positive integer
預設值:30Default value: 30

另請參閱See also

概念Concepts

安裝及設定 Access 應用程式的 Access Services in SharePoint Server 2013Set up and configure Access Services for Access apps in SharePoint Server 2013