Nothing looks amiss in the tables. When I try to open the forms, reports ... pages in the Import wizard it keep popping this error message 'Id' is not an Index in this table, and display nothing. I can't handle forms, reports... by any mean.
Tawtaw --- In [email protected], Trent Johnsey <[EMAIL PROTECTED]> wrote: > > Well, look at the system tables and see if anything looks amiss. (options/view/show) > > You might also try importing just the table definitions. Run your app to see if everything opens like it should. Another suggestion is to import tables/forms/reports/queries separately and test as you go along. Has the app been compiled? > > Try these, and let us know how it goes. > TJ > > > Ahmed Eltawil <[EMAIL PROTECTED]> wrote: 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 [email protected], 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 [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 > > > > > > > > > > > > > > > > > > > > > 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 > > > > > > > > > > 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 > Skip the bars and set-ups and start using Yahoo! Personals for free > > --------------------------------- > Yahoo! DSL Something to write home about. Just $16.99/mo. or less > ------------------------ 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/
