Set the database default instances limit
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 2000000Disable
# 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 SilentlyContinueOptions (1)
| Label | Control | Registry value | REG type | Constraints / details |
|---|---|---|---|---|
| Default number of instances returnedL_DatabaseDefaultInstancesLimitDecimal | Numeric boxdecimal | default | REG_DWORD | Min: 1 · Max: 2000000 |
Application
Microsoft 365 Apps / Office (Microsoft) — November 2026 templates
Official templates downloaded on November 12, 2026.