Corrupted Database

[Blorf]

Got a d/b that says "The Visual Basic for Applications project in the database is corrupt." when you try to open a table or any other thing.

It eventually opens, and lets you see the data. But will not compact and repair, and will not let me import into another database, gives the same message.

The format is 2000, I am using 2003.

Thanks for any help,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://www.thelegacyreturns.com/

 

[JoeAtWork]

Try doing a decompile on the database, with a command line something like:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /decompile "C:\MyDatabase.mdb"

 

[Ed2020]

This has worked for me on occasions when Compact & Repair has failed:

http://support.microsoft.com/kb/273956

Ed Metcalfe.

Please do not feed the trolls.....

 

[Blorf]

Thank you.

Sadly the command came back with the same message.

It's odd there are no modules even in the few forms.

Restored from a back up and data re-keyed so it's all good.

Thank you for the help.

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://www.thelegacyreturns.com/

 

[JoeAtWork]

Sounds like you have not split your database into a front-end / back-end solution. I would encourage you to do this, as that would make the back-end tables far less vulnerable to the corruption that often occurs in a database that contains VBA.

 

[Blorf]

Good advice. I follow it too.

The D/B belongs to another employee who, when all else failed, came to me.

Often when the sky has fallen, you folks here find the solution.



There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://www.thelegacyreturns.com/