Open in the explorer

Set query items limit

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

Explanation

This policy setting allows you to specify the maximum number of items that will be added to the client’s cache as the result of executing a query. Several bulk operations (especially queries) can return a large number of items to be added to the cache. This increases the size of the cache, potentially exceeding the 4GB limit imposed by Microsoft SQL Server CE. It also increases the amount of work required to keep the cache synchronized and increases the load on the LOB server. In order to protect the system, a limit is used – any results processed before reaching the limit are still committed, but the operation is marked as failed and will be retried later.

If you enable this policy setting, you may specify the maximum number of items that will be added to the client’s cache as the result of executing a query.

If you disable or do not configure this policy setting, a default value of 2000 items will be used.

Registry

HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\common\business data\synchronization
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_QueryInstancesLimit
$k = 'HKCU:\software\policies\microsoft\office\16.0\common\business data\synchronization'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
# Query instances limit
Set-ItemProperty -Path $k -Name 'query instances limit' -Value 1 -Type DWord  # between 1 and 32767

Disable

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

Revert to "Not configured"

# Revert to "Not configured": office16/L_QueryInstancesLimit
$k = 'HKCU:\software\policies\microsoft\office\16.0\common\business data\synchronization'
Remove-ItemProperty -Path $k -Name 'query instances limit' -ErrorAction SilentlyContinue

Options (1)

LabelControlRegistry valueREG typeConstraints / details
Query instances limitL_QueryInstancesLimitDecimalNumeric boxdecimalquery instances limitREG_DWORD
Min: 1 · Max: 32767

Application

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

Official templates downloaded on November 12, 2026.