Default file format
| Registry value | default file format |
| Group Policy | Default file format |
| German version | Standarddateiformat |
| Intune settings catalog | Default file format (User) |
| Scope | User · HKCU |
| ADMX | access16.admx · L_DefaultFileFormat |
Group Policy path
Registry
| Value | Data |
|---|---|
HKCU\Software\policies\microsoft\office\16.0\access\settings | |
| default file format | 12 = 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 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 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
- Do not prompt to convert older databasesnoconvertdialog
- Use Access 2007 compatible cacheuse2007compatiblecache
- Clear cache on closeclearcacheonclose
- Never cache datanevercache
- Block all unmanaged add-insrestricttolist
- List of managed add-ins
- Personal templates path for Accesspersonaltemplatesaccess
- Show custom templates tab by default in Access on the Office Start screen and in File | Newofficestartdefaulttab
All policies in this category · All 65 policies of access16.admx