CODEWITHSUNDEEP
vbams-access
Wofguy
Wofguy

Reputation: 1

Is there a way to extract Access Modules without opening the file?

I ended up corrupting my database to where every time I attempt to open it, I get error 3022, "changes you requested to the table were not successful because they would create duplicate values in the index."

Recovery of the file does not seem possible and my previous back up is a month ago. I have been able to extract everything but the Modules, which is what I need to recover the most. None of the standard ways I have found work because they require the ability to open the database (For example, trying to set it as a VBA reference still give the same error.)

Is there any way to get the modules or code out of the file without opening it?

Edit: Was finally able to get access to the file. Using DBEngine.CompactDatabase it was able to do a compact and repair. The issue has boiled down to the "MSysAccessStorage" table is corrupt, and says "Id is not an index in this table". I know have access to everything, except the modules, which I can't open without the MSysAccessStorage working.

I'm going to keep poking at it but I'm not sure what options I have for fixing a system table. Any ideas would be helpful.

Upvotes: 0

Views: 518

Answers (1)

Wofguy
Wofguy

Reputation: 1

Unfortunately, the Visual Basic for Applications project has been corrupted. The original database doesn't even have any VBProjects when listing a count. I'm going to call this one a lost cause. Thanks everyone that tried to help.

Upvotes: 0

Related Questions