Set maximum database instances limit
Explanation
This policy setting allows you to specify the maximum limit of how many instances per page the database shim can return. This policy setting enforces the allowed maximum for applications including those that do not respect the default.
If you enable this policy setting, you may specify the maximum limit of how many instances the database shim can return.
If you disable or do not configure this policy setting, there will be no limit of how many instances the database shim can return.
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_DatabaseMaxInstancesLimit
$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 }
# Maximum number of instances returned
Set-ItemProperty -Path $k -Name 'max' -Value 1 -Type DWord # between 1 and 2000000Disable
# Disable: office16/L_DatabaseMaxInstancesLimit
# No value is written in the "Disabled" state (nothing defined in the ADMX)Revert to "Not configured"
# Revert to "Not configured": office16/L_DatabaseMaxInstancesLimit
$k = 'HKCU:\software\policies\microsoft\office\16.0\common\business data\limits\database\items'
Remove-ItemProperty -Path $k -Name 'max' -ErrorAction SilentlyContinueOptions (1)
| Label | Control | Registry value | REG type | Constraints / details |
|---|---|---|---|---|
| Maximum number of instances returnedL_DatabaseMaxInstancesLimitDecimal | Numeric boxdecimal | max | REG_DWORD | Min: 1 · Max: 2000000 |
Application
Microsoft 365 Apps / Office (Microsoft) — November 2026 templates
Official templates downloaded on November 12, 2026.