goldylamont
asked on
Access Error: This action will reset your code...
Hello, I am at a total loss. I have been updating queries, etc in an Access database (I use version 2007 to work but the actual file is v2003/.mdb). Somehow now, seemingly randomly, when I open some reports and they are churning through data I get the dreaded error message "This action will reset your project..." with the click Yes/No dialogue. If I click No the report opens fine.
After this error occurs I can't Compact and Repair the database as I get an error saying that I can't compact/repair using VB code and that I should use the Start Menu instead (but I already am using the start menu to compact/repair). Also, there is no way to close the database at this point without MSACCESS.EXE then being pegged at 100% and having to force close.
It's weird because I can still use the database even after these errors (by clicking "No") but I can't close it.
I'm thinking this has to do with some recent code in modules that I may have added recently--problem is I don't know how/where to find this.
PLEASE READ: Below are steps I have ALREADY TRIED and this does not fix the problem:
1) Compact/Repair Database
2) open file using the /decompile switch
3) Removed all References in VB, quitting and then adding these References back
None of the above works, issue persists. Thanks!
After this error occurs I can't Compact and Repair the database as I get an error saying that I can't compact/repair using VB code and that I should use the Start Menu instead (but I already am using the start menu to compact/repair). Also, there is no way to close the database at this point without MSACCESS.EXE then being pegged at 100% and having to force close.
It's weird because I can still use the database even after these errors (by clicking "No") but I can't close it.
I'm thinking this has to do with some recent code in modules that I may have added recently--problem is I don't know how/where to find this.
PLEASE READ: Below are steps I have ALREADY TRIED and this does not fix the problem:
1) Compact/Repair Database
2) open file using the /decompile switch
3) Removed all References in VB, quitting and then adding these References back
None of the above works, issue persists. Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER