I have a big Access database, with aobout 150 Tables/Queries/Linked txt files/Macros/Modules.

I was working today, and then from out of nowhere the database got corrupted. I googled, and forund that exporting all the Objects into another database solves the Problem. I did that, and it worked on Objects and Queries, but Macros and Modules i can't Export... I alwasy get an error message: "id" is not an index in this table. And then Nothing happens. I also cant open the modules or the Visual Basic Editor. I tried the compact and repair tool, but It gives me the same error message multiple times. I tried to open the module in design mode, but get this error message "The module Name 'XY' is misspellen or refers to a module that does't exist. Everything I tried doesn't seem to work… The Macros are not so important, but the modules where a lot of work to put together…

Does anyone have an idea how I can repair These modules? Thank you so much for your help!

  • No backup? No mercy! You tried everything from stackoverflow.com/a/35871578/9439330? – ComputerVersteher Jul 25 '19 at 11:06
  • Yes... I tried all the steps there. I only don't have any Access to my modules and macros – Neymar0001 Jul 25 '19 at 11:15
  • You tried import instead of export? Also you read Access-Database-Corruption-Repair-Guide? If you can afford (company? or private?), they should be able to recover most data. – ComputerVersteher Jul 25 '19 at 11:24
  • I tried both, but could only save tables and queries – Neymar0001 Jul 25 '19 at 14:14
  • 1
    Glad to hear that mate! I hope you chosed a proper backup strategy (regular backups, indiependent hardware, regular restore test). A backup on the same machine and hdd is almost useless. And RAID is not a backup! – ComputerVersteher Jul 26 '19 at 8:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.