Open in the explorer

Set the database default instances limit

Type
User
GPO path
User Configuration › Policies › Administrative Templates › Microsoft Office 2016 › Business Data › Database
Supported on
At least Windows Server 2008 R2 or Windows 7
ADMX file
office16.admx
Internal name
office16/L_DatabaseDefaultInstancesLimit

Explanation

This policy setting allows you to specify the default limit of how many instances per page the database shim can return. The application is allowed to specify a larger timeout programmatically. This is a default value to be used by the database shim to restrict the number of results that can be returned per page. The application can specify a larger limit via execution context.

If you enable this policy setting, you may specify the default limit of how many instances the database shim can return.

If you disable or do not configure this policy setting, a default value of 200 instances per page will be used.

Registry

HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\common\business data\limits\database\items
Value name
not defined in the ADMX

Enable / disable values: not defined in the ADMX (see the options below).

PowerShell

PowerShell commands that write to the registry what the policy would write. Values in angle brackets (<…>) must be replaced.

Writing directly to the registry bypasses Group Policy: if a GPO manages this value, it will be rewritten at the next gpupdate; otherwise the value stays in place (the "tattooing" effect). Prefer a GPO or, locally, LGPO.exe. Run PowerShell as administrator for HKLM. Some policies need a restart or gpupdate /force.

Enable

# Enable: office16/L_DatabaseDefaultInstancesLimit
$k = 'HKCU:\software\policies\microsoft\office\16.0\common\business data\limits\database\items'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
# Default number of instances returned
Set-ItemProperty -Path $k -Name 'default' -Value 1 -Type DWord  # between 1 and 2000000

Disable

# Disable: office16/L_DatabaseDefaultInstancesLimit
# No value is written in the "Disabled" state (nothing defined in the ADMX)

Revert to "Not configured"

# Revert to "Not configured": office16/L_DatabaseDefaultInstancesLimit
$k = 'HKCU:\software\policies\microsoft\office\16.0\common\business data\limits\database\items'
Remove-ItemProperty -Path $k -Name 'default' -ErrorAction SilentlyContinue

Options (1)

LabelControlRegistry valueREG typeConstraints / details
Default number of instances returnedL_DatabaseDefaultInstancesLimitDecimalNumeric boxdecimaldefaultREG_DWORD
Min: 1 · Max: 2000000

Application

Microsoft 365 Apps / Office (Microsoft) — November 2026 templates

Official templates downloaded on November 12, 2026.