Corrupt VBA code

[dknj30]

I am using Access 2007. When I try to open my accdb I get a "The database cannot be opened because the VBA project contained cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project." message.

- I can't use the backup feature (i get the same error message)
- i can't compact and repair (i get the same error message)
- I can't move the forms into a new db (i get the same error message)
- i can't decompile (i get the same error message)
- when i save the forms as text - i get empty text files
- i can't open vba window (i get the same error message)

does anyone have ANY other ideas?!?!?

 

[Trevor G]

When looking to open your database try holding down the shift key and double click the icon (if a shortcut) and it should open the database and you should see the Navigation Pane.

 

[dknj30]

No dice. I get the same error message.
The navigation pane opens even without the shift (it's an accdb with nothing hidden).

 

[boblarson]

So you can't import everything into a brand new database file?

Also, is this split or not? If not, it should be so that you keep the data and the frontend separate. So then if the frontend corrupts, you just replace it with a new copy and the data doesn't get affected. If it isn't split and it corrupts then you probably lost everything.

If possible, get a backup copy restored by your system admin, if the file folder is backed up. Go back to the last known good time and the only bad thing is that any data from that point to now will need to be re-entered.

 

[vbaInet]

And if you don't have a Sys Admin, upload a copy of the db let's have a look. No guarantees though.