Set maximum database instances limit
| Registry value | max |
| Group Policy | Set maximum database instances limit |
| German version | Grenzwert für maximal zulässige Anzahl von Datenbankinstanzen festlegen |
| Intune settings catalog | Set maximum database instances limit (User) |
| Scope | User · HKCU |
| ADMX | office16.admx · L_DatabaseMaxInstancesLimit |
Group Policy path
Registry
| Value | Data |
|---|---|
HKCU\Software\policies\microsoft\office\16.0\common\business data\limits\database\items | |
| max | 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 @('max')) {
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 'max' -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 'max' -ErrorAction SilentlyContinue 'Policy values removed (Not configured).'
Intune (settings catalog)
Set maximum database 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_DatabaseMaxInstancesLimit |
| 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 maximum database 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 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.
Same category: Microsoft Office 2016 › Business Data › Database
- Set the database default instances limitdefault
- Set the database default timeoutdefault
- Set maximum database timeout limitmax
All policies in this category · All 945 policies of office16.admx