I had this happen once. It turned out to be mild database corruption that had deleted several of my indices. Use deisgn mode on the table that the message refers to and check that each index you expect to be there still exists, and if not, recreate it. A quick glace through your tables might be in order also - when this happened to me I also found a couple of spurious rows in the table that had lost its index. Good luck. cheers Cathy
-----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Ahmed Eltawil Sent: 04 December 2005 12:11 To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Error 3800 is not an Index in this table Hello, I'm having a problem with Access 2003 SP1. Some forms couldn't be opened and when I repaired the DB this message popped up 3 or 4 times: 'id' is not an Index in this table The message pops up every time I open the database and I can still open the tables and queries but not the Forms. I have no idea of what could be causing this problem, and I'd appreciate any help you could give. Tawtaw, Access developer ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/2jUsvC/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
