id is not an index in this table

[keno]

Hello everyone, am having this problem opennng my accdb 2007 db. I had just compiled a n XML code in the USysRibbon table commanding access to hide the default tabs and show my custom Ribbon. My database crushed on closure...as it was compacting ( I enabled compact on close option). I got the error "id is not an index in this table"; more and more pop same messages erupted when when I clicked OK. At time the message read "ParentidName is not an index in this table" It looped on for more than 50times and this happens the same when I attempt to open it. Now after the critical warning it can't open. I have read many suggestion on tens of access forums but all solutions given failed. I tried copying objects into new Database by both VBA and External Data options but still failed (same error occur). I duplicated a copy aside then ran VBA code from an external database to manipulate some System tables and I was able to open it. However, all forms, all modules and all macros were missing. This is so disturbing since I don't have any current backup copy...is there anyone with a good solution? Please help!!!

 

[JHB]

Have you tried to import one form, (in a new database), at a time and open it? (Always remember to take backup when you are developing.)