Office Admin Explorer

Default file format

Registry value
default file format
Group PolicyDefault file format
German versionStandarddateiformat
Intune settings catalogDefault file format (User)
ScopeUser · HKCU
ADMXaccess16.admx · L_DefaultFileFormat
Open in the interactive explorer+ Add to my collection

Group Policy path

User Configuration\Policies\Administrative Templates\Microsoft Access 2016\Miscellaneous
Benutzerkonfiguration\Richtlinien\Administrative Vorlagen\Microsoft Access 2016\Verschiedenes

Registry

ValueData
HKCU\Software\policies\microsoft\office\16.0\access\settings
default file format12 = Access 2007 · 10 = Access 2002-2003 · 9 = Access 2000

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\access\settings"
foreach ($name in @('default file format')) {
    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\access\settings"
    if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
    New-ItemProperty -Path $key -Name 'default file format' -PropertyType DWord -Value 12 -Force -ErrorAction Stop | Out-Null   # options: 12 = Access 2007, 10 = Access 2002-2003, 9 = Access 2000
    '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\access\settings"
Remove-ItemProperty -Path $key -Name 'default file format' -ErrorAction SilentlyContinue
'Policy values removed (Not configured).'

Intune (settings catalog)

Default file format (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/access16v2~Policy~L_MicrosoftOfficeaccess~L_Miscellaneous/L_DefaultFileFormat
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 Default file format. It also applies to unmanaged devices and wins over GPO and Intune for the same setting.

Microsoft explanation

This policy setting controls whether new database files are created in the new Access format or in a format used by earlier versions of Access.

If you enable this policy setting, you can specify whether new database files are created in Access 2016 format by default or in Access 2002--2003 format. Users can still override the default and select a specific format when they save the files, but cannot set the default by themselves from the Access Options dialog.

If you disable or do not configure this policy setting, when users create new database files, Access saves them in the new Access 2016 format; however, users can change this functionality by selecting a file format from the Default file format drop down list under Access Options | Popular | Creating databases. Note: If you disable this policy setting, users can choose from three default file formats: Access 2000, Access 2002--2003, and Access 2016. You can use this policy setting to specify either the Access 2002--2003 or Access 2016 format as the default, but not the Access 2000 format.

Same category: Microsoft Access 2016 › Miscellaneous

All policies in this category · All 65 policies of access16.admx