Recover VBA Code From Corrupted DB (1 Viewer)

[WayneRyan]

Hello all,

A coworker was developing an app to read XML files and had it working quite
well ... until he read over 2GB of data and the database went "brain dead".
He did have several backups, but all over a month old.

None of the usual fixes; /Compact, /Repair, importing to a new DB, etc. are
working at all.

The database always says "Can not open/find MSysDB".

Has anyone had any success retrieving code from a corrupted DB?

Thanks,
Wayne

 

[Banana]

I've seen others report success using LoadAsText / SaveAsText method. See if this will let you reach the database.

 

[WayneRyan]

Banana,

Thanks for the reply. The database is in the lab at work. I can't take it home due to sensitive data issues. All other methods of connecting to
the database result in the missing 'MSysDB'.

I did have luck with the /decompile before, but this is a 2007 database.

I'll have him try the LoadText Monday, hope it works, but I fear the app is hosed.

Thanks again,
Wayne