How to Fix Microsoft Access Crashing During VBA Refresh or Requery
Question details
The user needs to stop Microsoft Access from closing unexpectedly when triggering VBA Refresh or Requery commands on a form linked to SharePoint lists.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Updating records in a split Access database where the backend tables have been migrated to SharePoint lists.
- Observed behavior
- The database completely closes and crashes when executing Me.Refresh or Me.Requery in VBA, even though using the manual 'Refresh All' menu button works fine.
Verify your SharePoint site connectivity and ensure you have administrative access to the Microsoft Access front-end database before modifying linked tables or VBA code.
Verify Backend Storage Configuration
Determine if your backend is using native SharePoint lists or an improperly hosted Access database file.
A common cause for database instability is hosting the actual backend file directly on a SharePoint document library. This method is unsupported and leads to frequent crashes. You must ensure the tables are migrated as native SharePoint Lists.
Launch your Microsoft Access front-end database, navigate to the 'External Data' tab on the top ribbon, and click on 'Linked Table Manager'.
Look at the data source paths for your 19 linked tables. Confirm they are showing a SharePoint site URL icon indicating a 'SharePoint List' connection, rather than pointing to an .accdb or .mdb file hosted on SharePoint.
Refresh and Re-link SharePoint Tables
Corrupted or outdated linked-table configurations can cause VBA commands to time out and crash the application.
Modify the VBA Refresh Method
If Me.Refresh or Me.Requery consistently crashes the database, use alternative macro commands to force a safe update.
Looking for a Lightweight Alternative to Microsoft Office?
While Microsoft Access is a specialized database tool, many standard data management, tracking, and reporting tasks can be easily handled by WPS Office Spreadsheets. WPS Office is a free, lightweight suite offering high compatibility with Microsoft Word, Excel, and PowerPoint formats, making it perfect for streamlining your daily workflow.
Frequently Asked Questions
Why does Access crash only on a VBA Requery but not during a manual Refresh All?
A manual 'Refresh All' is handled differently by the Access engine's internal UI threads, while VBA 'Me.Requery' forces a full programmatic reload of the recordset. If the network connection to the SharePoint list drops or experiences high latency during this VBA execution, it can cause an unhandled exception that crashes the entire application.
Can I store my split Access backend file directly in a SharePoint document library?
No. Microsoft strongly advises against storing an Access back-end file (.accdb) directly on a SharePoint site, Teams channel, or OneDrive folder. It frequently leads to database corruption, synchronization conflicts, and random application crashes. You should instead migrate the tables to native SharePoint Lists.
How do I correctly migrate Access tables to native SharePoint Lists?
Open your Access database, navigate to the 'External Data' tab on the ribbon, select 'More' or 'Export', and click 'SharePoint List'. Follow the Export wizard to move your local tables into SharePoint lists, which will then automatically link them back to your Access front-end database securely.
