Open in the explorer

Set maximum database 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_DatabaseMaxInstancesLimit

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 2000000

Disable

# 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 SilentlyContinue

Options (1)

LabelControlRegistry valueREG typeConstraints / details
Maximum number of instances returnedL_DatabaseMaxInstancesLimitDecimalNumeric boxdecimalmaxREG_DWORD
Min: 1 · Max: 2000000

Application

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

Official templates downloaded on November 12, 2026.