'%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 Troubleshoot Microsoft Access Reserved Error (-2037) and ODBC Failures
Question details
The user needs to resolve Microsoft Access Reserved Error (-2037) and associated ODBC connection failures.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Attempting to run a database application, form, or macro that connects to an external data source via ODBC.
- Observed behavior
- The application throws Reserved Error (-2037) or an ODBC connection failure, preventing normal database operations or external data retrieval.
Before compiling your VBA code or altering database objects, verify that you have the correct administrative privileges in Windows and ensure that your target external database server is currently online and accepting connections.
Compile VBA Code and Run Compact and Repair
Identifying syntax errors in your VBA project and repairing database structure is the most effective way to resolve Error -2037.
The Reserved Error (-2037) is often triggered by faulty VBA code, corrupt event procedures, or broken macros. Because the error message is generic, isolating the exact cause requires checking the code and optimizing the database.
Open your database in Microsoft Access and press Alt + F11 to launch the Visual Basic for Applications (VBA) Editor.
In the VBA Editor menu, click on Debug and select Compile [Your Database Name]. Identify and fix any code syntax errors highlighted by the compiler.
Close the VBA Editor and navigate to the Database Tools tab located on the main Access ribbon.
Click on Compact and Repair Database to optimize the file and fix potential structural corruption.
Isolate Faulty Database Objects
Manually identify which specific form, macro, or startup object is causing the failure if compiling code does not help.
Troubleshoot the ODBC Connection
Resolve separate ODBC connection failures by verifying and updating external data source configurations.
Switch to WPS Office for Seamless Document and Data Management
While Microsoft Access handles complex relational databases, WPS Office provides a lightweight, free, and highly compatible suite for managing data through powerful spreadsheets, documents, and presentations.
Frequently Asked Questions
Why do I get a Reserved Error in Microsoft Access?
A Reserved Error in Access (like -2037) typically means the program has encountered an internal failure it cannot specifically identify. It is most commonly caused by corrupt database objects, faulty VBA code, or errors in startup macros.
How can I bypass startup errors to open my Access database?
You can bypass startup options and auto-executing macros by holding down the Shift key while double-clicking your Access database file. This allows you to enter the database workspace and troubleshoot faulty forms.
What should I do if the ODBC connection test fails?
If the ODBC connection test fails in the Data Source Administrator, ensure that the external database server is online, your network firewall is not blocking the connection port, and you have the correct ODBC driver installed for your specific data source.
Does the Compact and Repair tool fix VBA code errors?
No, Compact and Repair fixes database structural corruption and reclaims unused space. To fix VBA code errors, you must open the VBA Editor, run the Compile tool, and manually correct any highlighted syntax or logic errors.
