Office Admin Explorer

Set the database default instances limit

Registry value
default
Group PolicySet the database default instances limit
German versionGrenzwert für Datenbankstandardinstanzen festlegen
Intune settings catalogSet the database default instances limit (User)
ScopeUser · HKCU
ADMXoffice16.admx · L_DatabaseDefaultInstancesLimit
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
defaultdecimal 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 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 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

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