
Hi Beccy,
Try following these methods to fix your issue-
- Open the database, click on the "File" tab, then choose "Options." Select "Current Database" and select "Compact and Repair Database" in the Access Options dialogue box. This method helps in the correction of any possible database file corruption or problems.
- Go to "Tools" and choose "References" in the VBA editor to check for any missing or broken references. Ensure that all appropriate references are chosen and that none of the "MISSING" prefixed references are missing or damaged. Try to update or fix any outdated references that you find.
- Go to "Debug" in the VBA editor and choose "Compile [Your Database Name]." This will examine your VBA code for any syntactic or compilation issues. Correct any errors you find.
- As a last resort, you can try backing up your database and importing all the objects—tables, queries, forms, reports, etc.—into a fresh, empty database. Any underlying problems with the database file itself might get resolved.
Best Regards.