Set the database default instances limit
| Registry value | default |
| Group Policy | Set the database default instances limit |
| German version | Grenzwert für Datenbankstandardinstanzen festlegen |
| Intune settings catalog | Set the database default instances limit (User) |
| Scope | User · HKCU |
| ADMX | office16.admx · L_DatabaseDefaultInstancesLimit |
Group Policy path
Registry
| Value | Data |
|---|---|
HKCU\Software\policies\microsoft\office\16.0\common\business data\limits\database\items | |
| default | decimal 1–2000000 |
Not configured = the value does not exist – the application default applies and users may change the setting.
PowerShell
Check the current value (read-only)
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
$key = "$root\Software\policies\microsoft\office\16.0\common\business data\limits\database\items"
foreach ($name in @('default')) {
try { '{0} = {1}' -f $name, (Get-ItemPropertyValue -Path $key -Name $name -ErrorAction Stop) }
catch { '{0}: not configured' -f $name }
}Admin rights needed: HKCU\Software\Policies is read-only for standard users. An elevated session writes to the admin's own HKCU – to set it for another signed-in user, change $root to Registry::HKEY_USERS\<SID>.
Enable
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
try {
$key = "$root\Software\policies\microsoft\office\16.0\common\business data\limits\database\items"
if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
New-ItemProperty -Path $key -Name 'default' -PropertyType DWord -Value 1 -Force -ErrorAction Stop | Out-Null # range 1–2000000
'Done.'
}
catch { Write-Error "Failed: $($_.Exception.Message)" }Reset to Not configured
# --- Settings --- $root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>' $key = "$root\Software\policies\microsoft\office\16.0\common\business data\limits\database\items" Remove-ItemProperty -Path $key -Name 'default' -ErrorAction SilentlyContinue 'Policy values removed (Not configured).'
Intune (settings catalog)
Set the database default instances limit (User)
Settings catalog → Add settings → search for the name above.
Intune Settings Catalog Viewer ↗
Alternative: custom profile (OMA-URI)
| OMA-URI | ./User/Vendor/MSFT/Policy/Config/office16v2~Policy~L_MicrosoftOfficeSystem~L_BusinessData~L_Database/L_DatabaseDefaultInstancesLimit |
| Data type | String |
| Value | <enabled/> · <disabled/> |
This policy has options: add one <data id="…" value="…"/> per element after <enabled/>. The element IDs are in the ADMX file.
Cloud Policy
Cloud Policy (config.office.com → Customization → Policy Management) offers many user policies of the Microsoft 365 Apps – search for Set the database default instances limit. It also applies to unmanaged devices and wins over GPO and Intune for the same setting.
Microsoft 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.
Same category: Microsoft Office 2016 › Business Data › Database
- Set maximum database instances limitmax
- Set the database default timeoutdefault
- Set maximum database timeout limitmax
All policies in this category · All 945 policies of office16.admx