All tables imported just fine, however I can't import, open, open design any form, report, macro, seems that the problem is with a system table, I tried Microsoft Jet Compact Utility but nothing happened, any suggestions? Tawtaw
--- In AccessDevelopers@yahoogroups.com, Trent Johnsey <[EMAIL PROTECTED]> wrote: > > Try importing all of the tables into a new database instance. Depending on how bad the corruption is, the offending tables may or may not come over to the new instance. If the process hangs on a certain table (while trying to build indexes), then you have your answer. If it doesn't hang, then your indexes will have been rebuilt per original spec in the new instance. > > If a certain table fails, then you will have to remove the indexes (including primary keys), and run a query to find the records blowing up your indexes. if you remove the offending records, then the table should reindex just fine. if the reindex fails, then you haven't gotten all of the records. Records offending the primary key are normally the offenders. I would still import the now fixed table to the new instance. Hope this helps. Not that i have ever had to rebuild a blown up table before ;). > TJ > > Ahmed Eltawil <[EMAIL PROTECTED]> wrote: 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 AccessDevelopers@yahoogroups.com, "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: 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 > > > > > > > > > > > Please zip all files prior to uploading to Files section. > > > > --------------------------------- > YAHOO! GROUPS LINKS > > > Visit your group "AccessDevelopers" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > --------------------------------- > > > > > > > --------------------------------- > Yahoo! Personals > Let fate take it's course directly to your email. > See who's waiting for you Yahoo! Personals > > --------------------------------- > Yahoo! Personals > Skip the bars and set-ups and start using Yahoo! Personals for free > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/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/
