Thanks Cathy for ur quick response, the problem is that the error message doesn't specify a table name the database have about 120 tables how could I specify those tables causing the error. One of the suspected tables is a system table "MSysAccessStorage" which I can't change any thing in. Regards Tawtaw
--- In [email protected], "Cathy Jupp" <[EMAIL PROTECTED]> wrote: > > 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: [email protected] > [mailto:[EMAIL PROTECTED] Behalf Of Ahmed Eltawil > Sent: 04 December 2005 12:11 > To: [email protected] > 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 --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/I258zB/QnQLAA/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/
