Hi All,
I recently got an upgraded laptop with Windows 10 (64-bit) - previously was using Windows 7 (32-bit). Over the past couple days, my Access DB (.accdb file) keeps getting corrupt.. seems like whenever I modify something in the VBA Editor (in a Module or Class Module), the dreaded, "Database is in an inconsistent state" error will come up shortly thereafter. Thus far, it's able to repair the database each time - but prior to getting a new laptop, this never occurred.
Yesterday I ended up creating a brand new ".accdb" file and then importing all of the Forms/Queries/Reports/Modules from a backup version. The tables are all linked to a separate backend ".accdb" file (split database).
Currently I'm running into an issue where the modules are all listed in the Object Explorer, but then if I right-click on any of them and select "Design View", I receive the below error:
"The module name <xxxxx> is misspelled or refers to an object that doesn't exist".
If I go into the VBA Editor window, all of the Class Modules and Modules are missing.. They were there earlier this morning, but missing ever since I did another repair earlier today. Thoughts??![]()