'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Incorrect Data-Change Messages in Microsoft Access
Question details
The user is experiencing false data-change or transaction messages when closing a form in a single-user Microsoft Access database, likely due to a bug in a recent Microsoft 365 update.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Closing a form in a single-user database without any specific form-close code.
- Observed behavior
- Microsoft Access displays incorrect transaction or data-change prompts upon form closure, even when no data has been altered.
Ensure all Microsoft Office applications are closed and back up your Access database file to a secure location before running command-line updates.
Switch Microsoft 365 Update Channel via Command Prompt
Changing your Microsoft 365 update channel to the "Current" channel and forcing an update will apply the latest bug fixes to resolve the false prompts.
This issue is often tied to specific Microsoft 365 builds. By using an elevated Command Prompt to switch to the Current update channel, you can download a version of Office where this form-closing bug has been patched.
Press the Windows key, type "cmd" into the search bar, right-click on "Command Prompt", and select "Run as administrator".
Type the following command exactly and press Enter: "C:\Program Files\Common Files\Microsoft Shared\ClickToRun\OfficeC2RClient.exe" /changesetting Channel=Current
Next, type this command and press Enter to trigger the update: "C:\Program Files\Common Files\Microsoft Shared\ClickToRun\OfficeC2RClient.exe" /update user
Wait for the Microsoft Office updater window to appear and finish downloading the updates. Once complete, restart Microsoft Access and test closing your forms.
Need a More Stable Office Suite? Try WPS Office
While Microsoft Access is required for specific database management, bugs in Microsoft 365 updates can disrupt your daily workflow. For your document, spreadsheet, and presentation needs, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative without the hassle of forced, disruptive updates.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button.
- 2. Install WPS Office: Run the downloaded installer and follow the straightforward on-screen instructions.
- 3. Open Your Documents: Launch WPS Office to seamlessly open and edit your existing Microsoft Office files.
Frequently Asked Questions
Why is Access showing data-change messages when I haven't changed anything?
This is a known bug in certain builds of Microsoft 365 where the form's close event incorrectly triggers a transaction or data-change prompt, even in single-user databases with no close code.
What does changing the Microsoft 365 update channel do?
It changes how frequently your Office applications receive feature updates and bug fixes. The "Current" channel receives updates as soon as they are ready, allowing you to get immediate bug fixes for issues like this Access glitch.
Will running the OfficeC2RClient.exe command delete my Access database?
No, running this command only updates the Microsoft 365 application files on your computer. It does not affect, modify, or delete your personal databases or records.
