Office Admin Explorer

Set maximum database instances limit

Registry value
max
Group PolicySet maximum database instances limit
German versionGrenzwert für maximal zulässige Anzahl von Datenbankinstanzen festlegen
Intune settings catalogSet maximum database instances limit (User)
ScopeUser · HKCU
ADMXoffice16.admx · L_DatabaseMaxInstancesLimit
Open in the interactive explorer+ Add to my collection

Group Policy path

User Configuration\Policies\Administrative Templates\Microsoft Office 2016\Business Data\Database
Benutzerkonfiguration\Richtlinien\Administrative Vorlagen\Microsoft Office 2016\Geschäftsdaten\Datenbank

Registry

ValueData
HKCU\Software\policies\microsoft\office\16.0\common\business data\limits\database\items
maxdecimal 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 typeString
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

All policies in this category · All 945 policies of office16.admx