Export (0) Print
Expand All

Use Windows PowerShell cmdlets to manage Access Services in SharePoint Server 2013

SharePoint 2013
 

Applies to: SharePoint Server 2013 Enterprise

Topic Last Modified: 2013-12-18

Summary:Learn about the Windows PowerShell cmdlets that you can use to manage Microsoft Access service applications in SharePoint Server 2013.

Access Services is a service in SharePoint Server 2013 that lets an administrator view, edit, and configure a Microsoft Access service application within a Web browser.

All Access Services settings support backup and recovery, regardless of whether there is a UI setting in Central Administration. However, backup and recovery only apply to service-level and administrative-level settings; end-user content from the Access application is not backed up as part of this process.

Access Services has Windows PowerShell functionality that you can use to provision the service or provision a new instance that uses settings from a previous backup; configure and manage macro and query setting; manage and configure session management; and configure all the global settings of the service.

All cmdlets on this page are new to SharePoint Server 2013.

Index of Windows PowerShell cmdlets for SharePoint 2013 includes a complete list of all cmdlets in SharePoint 2013.

 

Cmdlet name Description

Get-SPAccessServicesApplication

Returns an Access Services application or a collection of Access Services applications.

Get-SPAccessServicesDatabase

Returns an Access Services database or a collection of Access Services databases.

Get-SPAccessServicesDatabaseServer

Returns the settings for all application servers.

Get-SPAccessServicesDatabaseServerGroup

Returns the settings for all application server groups.

Get-SPAccessServicesDatabaseServerGroupMapping

Returns the mapping from a source package type to the database server group.

New-SPAccessServicesApplication

Creates a new instance of an Access Services application in SharePoint Server 2013.

New-SPAccessServicesDatabaseServer

Adds a new SQL Server database to the list of servers.

Remove-SPAccessServicesDatabaseServer

Removes the specified database server.

Reset-SPAccessServicesDatabasePassword

Resets the passwords for all logons for user application databases.

Set-SPAccessServicesApplication

Sets global properties of an existing Access Services application in SharePoint Server 2013.

Set-SPAccessServicesDatabaseServer

Specifies whether or not a database in SQL Server is available.

Set-SPAccessServicesDatabaseServerGroupMapping

Sets server group mappings.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft