Problem with vb codes in MS Access

[history]

Hi brothers,

I've a very bad problem with my MS Access files, suddenly corrupted and give message : "The Visual Basic for Applications project in the database is corrupt."

The files could not be opened normally and when I click OK the buttons on forms are not working, in addition the modules are not accessible and Alt+F11 is not working.

Please I need help for this cause I lost all my codes and the files are useless !!!!

Waiting you brothers

 

[bob fitz]

Allen Browne has some good advice on handling corruption here

http://allenbrowne.com/tips.html#Corrupt

 

[history]

Thanks for fast reply

I'll see the link and get back to you with results

 

[Privateer]

If Allen's stuff doesn't work, consider opening a blank database and importing all tables, queries, and modules. Then import one form at a time and test its functionality. When you find the bad boy, it may corrupt again, and you may have to start over. But the next time, remark out all the suspecious code on that form and see if it works. Then narrow it down to the bad code or rebuild the form from scratch.

 

[history]

Hello again

The Allen Browne doesn't work unfortunately

I feel I'm lost

Please I need help

 

[bob fitz]

Have you tried Privateer's suggestion. I have had some success with that in the past.

 

[history]

Yes I've tried from the beginning, before posting this thread.

But no solution and gives me the same message :
"The Visual Basic for Applications project in the database is corrupt."

Still need help