'Id' is not an index in this table error help!
- Thread starter Rican
- Start date
- Local time
- Today, 15:22
- Joined
- Feb 28, 2001
- Messages
- 30,540
One of the things you can do in VBA is to specify an index to use when searching for something through recordset operations that specify key values for the search. (Possibly the SEEK method?) You can name the indexes of a table (just like you can name other objects.) The message says you named an index in a recordset operation but the index you named does not exist.
Hello everyone, am having this problem. 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!!!
