Database frequently corrupting. Can't solve. Please help. (1 Viewer)

• Error messages about can't find macro, can't find VBA code when clicking on something (as if the macro and VBA coding have vanished underneath)
• Error message Cannot open database '', expression may not result in name of a macro or event procedure, detected database in an inconsistent state, cannot be opened because VBA project cannot be read, unrecognized database format etc
• User using the database then leaves it idle for a while, comes back, can't click anything (one or more of the errors above), then crashes
• User using the database and the above happens as they are actively using it (although the idle one above is more common than this one)

• Create new blank database, import everything into it (this seemed to work well for a while and then the corruption started again)
• Decompile / recompile / compact/repair
• Removing references, adding references
• Creating ACCDE
• Repairing Office
• Ensuring Windows and Office up to date via Windows Update

• I have been developing the master ACCDB for the last 10 months under my adminatrative remote desktop on the server, I have never once encountered the corruption the users are getting
• The users each have a restricted remote desktop on the server, locked down by GPO (can't access internet, can only open office docs, etc)
• I have a test login with the same restrictions as the users that I have used the database in for hours and days at a time without encountering the error (ie it's very hard to replicate, random)
• The users will get the corruption on average two or three times per day - no pattern to when, which screen/report, which user, sometimes not at all - all "random"
• I managed to copy one of the user's database when they got the error and the VBA code in the database was inaccessible (in fact it looked like it just wasn't there)

copies the ACCDB from a central location to their local documents which is where they access it.

Click to expand...