Fix Microsoft Access No Current Record and Invalid Argument Errors
Question details
Users are encountering errors when attempting to close Microsoft Access forms that contain datasheet subforms linked to SharePoint lists.
- Product
- Microsoft Access 365
- Device & OS
- not provided
- Scenario
- Closing database forms with datasheet subforms that are actively linked to SharePoint lists.
- Observed behavior
- The application displays 'No current record' and 'Invalid argument' errors. Using the Compact and Repair tool only provides a temporary resolution, and the error eventually returns.
Ensure you have a complete backup of your Microsoft Access database file (.accdb) and verify if your Microsoft 365 environment recently underwent an automatic update.
Update Microsoft Office to the Latest Patched Version
Since this specific issue is often tied to a bug introduced in a Microsoft Office update, installing the newest hotfix or patch from Microsoft is the most effective permanent solution.
Microsoft periodically releases updates that can sometimes break specific functionalities in Access, such as SharePoint list synchronizations. Checking for the latest updates ensures you have the official patch for this known bug.
Launch Microsoft Access, click on 'File' in the top-left corner, and navigate to the 'Account' tab at the bottom of the menu.
Under the Product Information section, click on the 'Update Options' drop-down button.
Select 'Update Now'. Allow Microsoft 365 to check for, download, and install any available updates. Once completed, restart Access and test the form.
Refresh and Relink SharePoint Tables
Refreshing the connection between your Access database and the SharePoint lists can clear out synchronization errors causing the invalid argument prompts.
Switch to WPS Office for a Stable Document Experience
While WPS Office does not feature a database management application like Access, it serves as a highly reliable, lightweight, and free alternative for all your standard productivity needs. If you are frustrated by frequent update bugs in Word, Excel, or PowerPoint, WPS Office offers a seamless and stable environment.
Frequently Asked Questions
What causes the 'No current record' error in Microsoft Access?
This error generally happens when Access tries to read, update, or reference a record that has been deleted, does not exist, or when a synchronization bug breaks the link between the front-end form and the back-end data source.
Why does Compact and Repair only fix the issue temporarily?
The 'Compact and Repair' tool optimizes the database and fixes minor corruptions. However, if the root cause is a software bug from a recent Microsoft Office update or a persistent network sync issue with SharePoint, the error will reoccur during standard use.
How can I prevent SharePoint linked tables from causing errors in Access?
To minimize errors, ensure a stable internet connection, avoid having multiple users heavily editing the exact same records simultaneously (which causes locking conflicts), and keep your Office installation updated to stable, patched builds.
